8 Replies Latest reply on Jun 18, 2018 1:35 AM by Sohan Jawar

    Calculation problem

    Niranjan Banarjee

      Hi,

       

      Can anyone help me what is wrong with the below formula.

       

      Requirement: To calculate Share difference. Example=April 2018 share = Val/Total(Val) - April 2017 share

       

      ZN(SUM([Val])/TOTAL(zn(SUM([Val]))))-

      (ZN(SUM([Val])) - LOOKUP(ZN(SUM([Val])), -12)) /Total((ZN(SUM([Val])) - LOOKUP(ZN(SUM([Val])), -12)))