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,

      Tanguy