Aggregation with Multiple If Conditions

[danyal1990]

Dear All,

I am writing an expression to calculate if the store is how many times compliant in that specif KPI and then sum those all occurrences to make it an overall result. But i am stuck in if conditions and it is not working as expected.

Can you please help me out where i am making mistake?

=if(count(if(Store_category='Supermarket' and Parameter='KPI-1' and [KPI Compliance]='C', Category))>=3,1,
count(if(Store_category='Pharmacy' and Parameter='KPI-1' and [KPI Compliance]='C', Category))>=4,1,0)

[danyal1990]

Please help guys!

[Brett_Bleess]

It would be very helpful if you attach your QVW file on this one so folks can look at the data model in addition to the properties of the objects too.  If you have sensitive information, you can use Settings\Document Properties\Scrambling tab to protect those prior to posting the file.

Regards,
Brett