I have a table where I have null values that I wish to replace with the previous value. i.e. As per the screenshot, the left hand table is the original table....and the RH table is the desired end result. Numbers in red are those that I wish to 'add'
I have tried
if (isnull([X])) then previous[X]) else [X] but this doesnt work..... any ideas?
BI 4.1 Webi SP4