Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I have the table as shown below;
I am trying to calculate the MTD Variance which is (Current month YTD) - (Previous month YTD) with the expression as;
Sum(YTD)
-
Sum({$< Snapshot_Date = {$(vPreviousMonth)}>}YTD)
where PreviousMonth is a variable defined as
Let vPreviousMonth = '=MonthEnd(AddMonths((Snapshot_Date),-1))';
The above expression returns null values, what wrong am I doing here? any help is appreciated
thanks
Check attached.... you don't need set analysis here... but Inter-Record Functions
Ah, thank you stalwar1 for the information. This is what I am looking for
stalwar1 when we use Above() here it is calculating per row basis (current row minus previous row) not considering the project numbers and country selected. Any idea on how to avoid this?
Can you share this in a qvw file and also make sure to provide the expected output
stalwar1 Since this thread has been closed I have created another question. Please find the link here Calculate current month YTD minus previous month YTD
thank you
Okay, looking at that now