13 Replies Latest reply: Jan 15, 2018 7:53 AM by Anil Samineni RSS

    How to write a expression

    naveen kunuru

      Hello All,

                        I need help in writing a expression ,the below table as three dimensions

                                                                                                 1)Material Code,2)Vendor code,3)Plant code

              and Four expressions    

                                                   1)Residual:    sum({<[FISCAL YEAR]=>}Resi)

                                                   2) VolumeFY2017(16-17):  Sum({<[FISCAL YEAR]={'$(=max([FISCAL YEAR])-1)'}>}VOLUME)                                                                3)    Column(1)*Column(2)

                                                  4)Savings Potential :

      sum(aggr(

      Sum({<[FISCAL YEAR]={'$(=max([FISCAL YEAR])-1)'}>}VOLUME)*sum({<[FISCAL YEAR]=>}Resi])

      ,[MATERIAL CODE],[VENDOR CODE],[PLANT CODE]

      ))

      Capture.PNG

      So the problem is when i use column(1)*column(2) iam getting 29973.741(203.903*147) which is correct but

      when i am trying to use along with aggr function i am getting Zero ,

      so kindly any one suggestion what am i missing in my expression 4th, or is there any other way to write the above expression

       

       

      Thanks