Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear Experts,
I am writing this expression:
=if((sum([Pre-Tax Value])/VTotalPreTaxValues)>'02.00%', CustomerName)
I have to display only those Customer whose % value is greater than 2.00%, I am using above expression but it is not giving any customer name...
Please suggest....
Regards,
Balraj
in your expression you are comparing the value of sum(pretax)/vtotal... with the string '02.00%' and i don't think they are saved like that in your schema right? the 2.00% is probably a number formatting in the chart that you are using, so check first what does this expression returns sum([Pre-Tax Value])/VTotalPreTaxValues) and then add the filter.
maybe it should be sum([Pre-Tax Value])/VTotalPreTaxValues) > 0.2