Calculating expression based on variable

[vijetas42]

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

[bharathadde]

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)

[vijetas42]

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!