9 Replies Latest reply: Jul 12, 2017 12:01 AM by Dushan Chathuranga Basnayaka RSS

    Dimension Help

    Dushan Chathuranga Basnayaka

      Hi Friends,

      I want to create a dimension in coding or pie chart in design using below measures. Is there any way to do that. please help. Thanks

       

      PAR 7 =sum(If(ArrearsRentals>0,(CapitalArrears/ArrearsRentals),0))

      PAR 14 =Sum(If(ArrearsRentals>1,(CapitalArrears/ArrearsRentals),0))

      PAR 30 =Sum(If(ArrearsRentals=3,(CapitalArrears/ArrearsRentals),If(ArrearsRentals>3,(CapitalArrears/ArrearsRentals)*2,0)))

      PAR 60 =Sum(If(ArrearsRentals=5,(CapitalArrears/ArrearsRentals), If(ArrearsRentals=6,(CapitalArrears/ArrearsRentals)*2,                If(ArrearsRentals=7,(CapitalArrears/ArrearsRentals)*3, If(ArrearsRentals>7,(CapitalArrears/ArrearsRentals)*4,0)))))