Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
How to combine into one formula:
Sum({$<Year={$(=Max(Year)-1)}, ST={'N'}>} BALANCE)+Sum({$<Year={$(=Max(Year)-1)}, ST={'N'}>} SUBCHARGE)
Additional:
If I want to? Use sum total ?
Sum({$<Year={$(=Max(Year))}, STATUS={'Y'}>} BALANCE)+Sum({$<Year={$(=Max(Year))}, STATUS={'Y'}>} SUBCHARGE) then divide
Sum({$<Year={$(=Max(Year)-1)}, STATUS={'N'}>} TOTAL)
Thank you.
Hi,Sheann
what is your problem? It's possible like this:
Sum({$<Year={$(=Max(Year)-1)}, ST={'N'}>} BALANCE + SUBCHARGE)
Sum({$<Year={$(=Max(Year)-1)}, ST={'N'}>} BALANCE + SUBCHARGE) /
Sum({$<Year={$(=Max(Year)-1)}, STATUS={'N'}>} TOTAL BALANCE +SUBCHARGE)
Greetings from Munich
Martina
EVACO GmbH
Hi Martina,
Thnak for your help.
Sum({$<Year={$(=Max(Year)-1)}, ST={'N'}>} BALANCE + SUBCHARGE) don't work. MY bar disappear after change to this formula.
Hi, Sheann,
did you select a year? Set Analysis maybe exprect to select a year. I tried this expression in my application and it works fine.
Greetings from Germany
Martina
EVACO GmbH