Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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])
Hi Sunny, Thanks for response i did the same thing and it is working fine now.