5 Replies Latest reply: Jun 17, 2015 10:02 AM by Sunny Talwar RSS

    Problem with calculating expression

    Андрей Шепель

      Hi everyone!

       

      I have some problem with correct calculating expression in my model.

       

      I have pivot table, where i calculate expression result by dimension YearMonth as:

      =sum(Quantity*Sum)

      There is Quantity in every YearMonth, but not Sum.

      What i need: If there no sum for some YearMonth, get it from nearest previous YearMonth.

       

      For example:

      In YearMonth 201505 there no sum, that's why in this row i need get neares sum from YearMonth 201504 = 22*4=88

      In YearMonth 201506 there no sum, that's why in this row i need get neares sum from YearMonth 201504 = 12*4=48


      There're model and source file for my task.


      Please, help to solve this problem.