Forum Discussion

romovaro's avatar
romovaro
Responsive Resident
4 years ago

Adding new requirement formula

  Trying to add a new requirement in the formula Formulas are working fine but now I need to add an extra filter   && (Task = "IPM HandOff) and Task Status Closed   Tried to add:   CALCULATE...
Need Help
romovaro's avatar
romovaro
Responsive Resident
4 years ago

Hi amitchandak

 

In the formula below it's missing the fields with the string "partner Acknowledgment"

 

CALCULATE(COUNTROWS(CELERGO_12062021V1),Filter( CELERGO_12062021V1, CELERGO_12062021V1[TASK] ="IPM HandOff" && CELERGO_12062021V1[TASK_STATUS]="Closed"))

 

 

Total Tasks = CALCULATE ( COUNTA ( CELERGO_12062021V1[TASK] ), CONTAINSSTRING ( CELERGO_12062021V1[TASK], "Partner Acknowledgement")).... and I am trying to add...the filter to add...and 

CELERGO_12062021V1[TASK] ="IPM HandOff" && CELERGO_12062021V1[TASK_STATUS]="Closed")
 
 
 
My problem is adding this "extra requirement" in the 3 formulas above.

CELERGO_12062021V1[TASK] ="IPM HandOff" && CELERGO_12062021V1[TASK_STATUS]="Closed")