5 Replies Latest reply: Apr 15, 2015 4:40 AM by Vidas Rojus RSS

    Dimension calculation

      Hi,  need help with calculation of dimension

      I have a data (see example below) and I need to make calculation for Debit code.

      I create dimension as Debit code and measure as Sum(Value).

      Result (I need for my calculation for Debit code 6000) 935+125-1200=-140.

      In other words value of Debit code dimension minus value of Credit code dimension.

      Debit code      Credit code      Value

      6000               20140               935

      6000               20140               125

      500                 6000               1200

      300                 20140               200


      Thanks in advance for help.