10 Replies Latest reply: Mar 28, 2017 10:07 AM by Tanguy de Becdelievre RSS

    Aggr Function with If Statement

    Tanguy de Becdelievre

      Good morning,


      I am having difficulties with 1 formula.


      It works perfectly on a Table but when I try to put it on a KPI object, the function does not work.


      The formula is the following:


      if(Max({<QTYCONSUMED={"<0"}>}[MONTH ORDER])>=(vOPENBAL-12),sum(Amount))


      Any idea on how to solve this issue ?


      Thanks for your help,