Skip to main content
Announcements
July 15, NEW Customer Portal: Initial launch will improve how you submit Support Cases. IMPORTANT DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Combine two sum formulas

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.

3 Replies
brenner_martina
Partner - Specialist II
Partner - Specialist II

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

Not applicable
Author

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.

brenner_martina
Partner - Specialist II
Partner - Specialist II

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