Comparison

[paulwalker]

Hi Community,

PFA,

Please anyone give some suggestions.............

Regards,

Paul

[Anonymous]

Paul

Could you clarify what you mean by show count of ALERT , as I can see no field called ALERT in your data model.

Best Regards,     Bill

[paulwalker]

Hi Bill,

Alert means already i calculated field in my STRAIGHT table

Actually i want to show alerts count.... and Comparison with MonthlyCoverage and ActualDemand

[Anonymous]

Paul

You could create a field called Alert in your load script :

If ([Actual Demand]>[Monthly Coverage] ,Dual('Alert',1) , Dual('Ok',0))     as Alert ,

Then simply use the Sum() function to give you the count :

Sum ( [Alert] )

If you are not familiar with the Dual function, then look it up in the Help.

Best Regards,    Bill