Forum Discussion

mape's avatar
mape
Frequent Visitor
8 years ago

In a matrix, How I can replace the empty values in cells for the value in previous period?

Hi everyone!! I need help about this...   Measure of sales per year and in case there is no information for that year, show the sales of the previous year.   That is, given a series of sales per ...
Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
8 years ago

In general, you would need an IF statement that checked if the value was BLANK() and if it is not, return the value, otherwise, return the PREVIOUSYEAR value.