Business Analytics Calculation

johanna

Hi all,

I need to modify calculation in BA Advanced Client, but still confuse to learn from its help (F1). Could somebody tell me where I can get another resource to learn advanced formula calculation in Business Analytics Client or give me information about using advanced calculations ?
Thank you.

johanna

I want to make advanced calculation in Business Analytics Advanced Client. I want to count the ValueEntry_SalesAmount_Actual_ that have amount > 0. I have tried to using count(0,all,m1) but it count every non-empty value (including 0 value). How to make the count only count ValueEntry_SalesAmount_Actual_ that have amount > 0 ?
Please help me. Thank you.

johanna

Dear all,

God has given inspiration to me about this issue.
The solution is add new column that is given value 1 if its amount > 0 then add new row to sum it.
Thanks God and Thanks all