7 Replies Latest reply: Jan 10, 2017 3:15 AM by Christian Buela RSS

    Question regarding an expression

    Madeleine Josefsson

      Hi,

      I have a table showing budget numbers per month like this:

      And now I want to change so that the numbers are not spread even across 12 months, i.e using budget keys and I have these in an excelsheet ordered like this:

      How can I add the budget keyes in my expression? I tried to do it like this: sum({$<PlanVersionId={'PV4000013'}>}Amount)* Sum(BudgetKeyAQMFI)

       

      But this does not work, it gives me the correct total sum of the budget, however the sum per month is not correct. See here:

       

      How come the total of the budget is correct, but the numbers for each month looks incorrect?( 3330128 x 7% = 233108,96)

       

      Thanks!