Hi,
I have a need to calculate YTD Actuals but the amount should show the sum of values from start month (Jan 19) to One month prior to the current period i.e (July 19).
The current formula I have is this: YEARTODATE('P&L by Cost Center'.Amount Adj[LOOKUP: Version Selector.Actuals])
I need to pull YEARTODATE just until end of last month which is in my case end of July 19.
Let me know.
Thanks
Phani