Set analysis Expression Challenge

[chaitanyajami]

Hi all,

I have a challenge like iam calculating count of [Quote Number DMP] when [Quote Number Status]= Approved like below

count({<[Quote Status]={'APPROVED'}>}[Quote Number DMP])

now my requirement is to include another condition where count to be calculated when the field value [Approver job name] equals to [Requester job name], kindly suggest how can i achieve it

[sunny_talwar · Accepted solution]

Or if [Approver job name] = [Requester job name] are coming from the same table in the backend, then create a flag in the script

LOAD [Approver job name],

     [Requester job name],

     If([Approver job name] = [Requester job name], 1, 0) as Flag

     ....

FROM ...

and then this

Count({<[Quote Status] = {'APPROVED'}, Flag = {1}>} [Quote Number DMP])

[chaitanyajami]

Hi Sunny, Thanks for response i did the same thing and it is working fine now.