1 Reply Latest reply on Nov 22, 2014 5:55 AM by KK Molugu

    Calculation Issue Sum Distinct

    ankit.narula

      Hi All,

       

      I am stuck on a calculation where my daily target is showing correct value however monthly target is not correct.

      I am using calculation:

      IF (FIRST()==0)  THEN   

      WINDOW_sum(max([Test Qty]), 0, IIF(FIRST()==0, LAST(), 0))   

      END

      Attached is the screen shot.

      I want to display monthly target to be same as daily and not sum.

       

      Thanks