8 Replies Latest reply: Nov 24, 2017 7:54 AM by omar bensalem RSS

    Calculated dimension based on a value of one of the cells

    Leszek Piekielniak

      Hello,

       

      I need to create calculated dimension in the table as below:

         

      ChgPostChgOutCalculated
      100001000
      150015001500
      2000200
      3000300
      0300300
      0350350
      250250250
      300250250

       

      so Calculated = ChgPost  but if ChgPost = 0 then Calcuated = ChgOut.

       

      I used the below formula:

       

      If(ChgPost=0,ChgOut,ChgPost)

       

      but it looks like the calculated = ChgPost+ChgOut

       

         

      ChgPostChgOutCalculated
      100001000
      150015003000
      2000200
      3000300
      0300300
      0350350
      250250500
      300250550

       

      Could you please advice how to fix it?

       

      Thanks,

       

      Leszek