Business Analytics Calculation

johanna
johanna Member Posts: 369
edited 2010-12-02 in NAV/Navision Classic Client
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.
Best regards,

Johanna

Answers

  • johanna
    johanna Member Posts: 369
    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.
    Best regards,

    Johanna
  • johanna
    johanna Member Posts: 369
    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 :)
    Best regards,

    Johanna

Categories