1 Reply Latest reply on Feb 11, 2019 7:04 PM by Zhouyi Zhang

    Calculation error

    Naryb sarah

      Hi Team,

       

      i am trying to do total and subtotal for the hierarchy field but it should restrict duplicate data.

       

      Example:

       

       

      Item code subtotal = 40,80,40

       

      Order Num sub total = 120,40

       

      But State total should be 140, because itemcode1 repeated twice it should be consider only once.

       

      i tried using size() functionality get the results but i am unable to get the results.

       

      IF SIZE() =1 THEN SUM(SALES) END

       

      Can some help me.

       

      Thank you