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])
Hello Chaitanya,
Below is the draft version of expression:
If([Approver job name]=[Requester job name], count({<[Quote Status]={'APPROVED'}>}[Quote Number DMP]))
Could you please share the application with sample data? This will help me to provide you more accurate solution.
Regards!
Rahul
Hi Rahul,
Here is my sample data looks like(i cannot copy app due to security restrictions) , and i tried the above expression somehow it was not working
Hello Chaitanya,
As I could see that you have list boxes for Approver Job Name & Requester Job Name fields. Where exactly you are planning to use this expression? If it is inside straight table then what other dimensions are there?
Regards!
Rahul
Hi,
May be try like this
=count({<[Quote Status]={'APPROVED'},
KeyField={'=[Approver job name]=[Requester job name]'}>}
[Quote Number DMP])
Hi Rahul,
basically when 'Approver Job Name' value equal to 'Requester Job Name' value then we are calculating the count of 'Quote Number DMP' (with condition [Quote Status]={'APPROVED'}), we are showing this in a textbox
Hi,
key field is not there , we just need to calculate when 'Approver Job Name' value equal to 'Requester Job Name' value then count of 'Quote Number DMP' (with condition [Quote Status]={'APPROVED'})
Have you tried the Rahul's expression?
also check this..
=Count(Aggr(if([Approver job name]=[Requester job name] and [Quote Status]='APPROVED',[Quote Number DMP]),[Approver job name],[Requester job name]))
Hi,
I have tried Rahul's expression it was not working, Ok i will try this Thank you
Give this a try as well
Count({<[Quote Status] = {'APPROVED'}>} If([Approver job name] = [Requester job name], [Quote Number DMP]))