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(COUNTROWS(CELERGO_12062021V1),CELERGO_12062021V1[TASK] ="IPM HandOff" && CELERGO_12062021V1[TASK_STATUS]="Closed"))) but is not working

 

Could you help me? 

 

Total Tasks = CALCULATE ( COUNTA ( CELERGO_12062021V1[TASK] ), CONTAINSSTRING ( CELERGO_12062021V1[TASK], "Partner Acknowledgement"))….+ Extra Filter

Showing Total of tasks that contains the string “Partner Acknowledgement” and have task “IPM HandOff” closed.

 

 

 

Partner Acknowledgment with GLD = CALCULATE ( COUNTA ( CELERGO_12062021V1[SCHEDULED] ), CONTAINSSTRING ( CELERGO_12062021V1[TASK], "Partner Acknowledgement" )) ….+ Extra Filter

Showing Total of tasks that contains the string “Partner Acknowledgement” , have a schedule date and have task “IPM HandOff” closed.

 

 

Partner Acknowledgment with GLD & Closed = CALCULATE ( COUNTA ( CELERGO_12062021V1[SCHEDULED] ), CONTAINSSTRING ( CELERGO_12062021V1[TASK], "Partner Acknowledgement" ) && CELERGO_12062021V1[TASK_STATUS] = "Closed" ) ….+ Extra Filter

Showing Total of tasks that contains the string “Partner Acknowledgement” and task status Closed, have a schedule date and have task “IPM HandOff” closed.

 

 

Thanks

Need Help

3 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    4 years ago

    romovaro ,It should work , try like

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

     

    or

     

    Partner Acknowledgment with GLD = CALCULATE (COUNTA ( CELERGO_12062021V1[SCHEDULED] ), filter(CELERGO_12062021V1, CONTAINSSTRING ( CELERGO_12062021V1[TASK], "Partner Acknowledgement" ))
    )

     

  • 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")

  • v-jingzhang's avatar
    v-jingzhang
    Community Support
    4 years ago

    Hi romovaro 

     

    This topic is similar to this thread you posted earlier, can you help close this one? Thank you. You can accept a reply as solution to close it. 

     

    Best Regards,
    Community Support Team _ Jing