Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All
when i filter Reporting Code = 50010 , correct result is -120,107,846.65
= money(
if([Exec P&L Level] = 's','',Sum({$<year = {$(=max(year))}, month = {"<=$(=max({<year={$(=max(year))}>} month))"}>}[Amount]*-1)/1000)
, $(vMoneyFormatK_GL))
Now i get 14,031.85 K , may i know how to make it -120,107,846.65 ? when i dont select month and year.
Paul
Try this:
=Money(RangeSum(
Above(RangeSum(Above(If([Exec P&L Level] = 's', '', Sum({<year, month>}[Amount]*-1)), 0, RowNo()))),
-Sum(TOTAL Aggr(If([Exec P&L Level] = 's', '', Sum({<year, month>}[Amount]*-1)), YearMonth)))
, $(vMoneyFormatK_GL))
Hi Sunny
Look Like it does not work in my QV Ver.
As the figure look funny. Any work around ?
Paul
Do you have these selections?
When I open your file, I see this:
Could be a version issue, not sure
i have same current selection .
Something to do with different version I guess. Don't really know what is wrong Paul
Hi Sunny
Yes look like i am having the ver issue , it is possible to have alternative . can i try using load script ? see does it help ? or wait let me try do in QS.
Ya, I think it would work in QS.
Hi Sunny
In QV Any work around ?
Script based solution can work, but won't be dynamic and might not changed based on selections.