Skip to main content
Announcements
Customer Spotlight: Discover what’s possible with embedded analytics Oct. 16 at 10:00 AM ET: REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

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.


1 Reply
morganaaron
Specialist
Specialist