Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
We have all the calculation adhoc in straight table even for flag which based on the difference between two values.
now, I want to calculate count of accounts based on that flag.
Any idea how can we achieve this.
for Flag, we have calculated expression like, if($(vDifference) <0,'Bad',if((vDifference) >0,'Good','No Change'))
Regards,
Vijeta
For count of accounts with Bad
=Count({<flag ={'Bad'}>}Accounts)
For count of accounts with Good
=Count({<flag ={'Good'}>}Accounts)
For count of accounts with No Change
=Count({<flag ={'No Change'}>}Accounts)
this flag is calculated on the fly in variable which has expression, if($(vDifference) <0,'Bad',if((vDifference) >0,'Good','No Change')).
I don't have direct flag field
Thanks!