1 Reply Latest reply: Jun 19, 2015 7:00 AM by Aaron Morgan RSS

    Populate missing sum with necessary values

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

      Good day!

      I have qvd file with fields:

      Revenue with VAT price

      Revenue w/o VAT price

      Net revenue price

      Net net revenue price

      These fields agregated by PricesKey and YearMonth.

      For some YearMonth values (Revenue with VAT price,Revenue w/o VAT price,Net revenue price,Net net revenue price)  is null.

      In these cases i need get values from nearest previous YearMonths.

      Many thanks for help.