Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I am loading data with
EDW:
LOAD date(Date-1) as prevDate,
Date,
[Business Area Code],
[Closing Balance USD]
FROM...
Calendar:
LOAD
date(Date-1) as prevCalDate,
Date,
[Document Date],
[PGS Date],
[Close WD],
[Close Period],
[Period WD],
[Calendar Month],
FY
FROM...
I need to have a Straight Table to show the Current Date -Current Date Balance - Previous Date - Previous Date Balance.
The expression that I am using is returning the same balance as the Current Date.
(sum({$<prevDate=p({$<prevDate>}prevDate)>}[Closing Balance USD]).
Below is a look at the Straight Table.
Here is what the totals should be:
Attached is the Data file:
Thanks!
Dan
Try
sum({$<Date=p(prevDate)>} TOTAL [Closing Balance USD])
This will probably only work with a single Date selected.
Thank you Swuehl, worked perfectly!
Swuehl,
I now have another need for the Previous Month to the Date to sum up [Closing Balance USD].
Can you help?
Thank You Swuehl!
I tried a few combinations and it did not provide any $$ amounts.