Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Good day everyone.
I have a problem,
For a client of mine we do calculations to display 5 years of revenue in a single chart.
This is the formula I can use for this:
sum({<Year={">=$(=max(Year)-4)<=$(=max(Year))"}>}GLE15_DB)
But now I must make a graphic over 5 years but on the following calculation:
if(sum(GLE15_DB) > sum(GLE15_CR), sum(GLE15_DB) - sum(GLE15_CR))
Does anyone now how I integrate the second formula into the first?
Data set analysis isn't my strong suit yet and I don't know how I should structure the formula.
Thanks in advance.
Dries
You will need to implement the set in all sub expressions like this:
If(sum({<Year={">=$(=max(Year)-4)<=$(=max(Year))"}>}GLE15_DB) > sum({<Year={">=$(=max(Year)-4)<=$(=max(Year))"}>}GLE15_CR),
sum({<Year={">=$(=max(Year)-4)<=$(=max(Year))"}>}GLE15_DB) - sum({<Year={">=$(=max(Year)-4)<=$(=max(Year))"}>}GLE15_CR)
)
You will need to implement the set in all sub expressions like this:
If(sum({<Year={">=$(=max(Year)-4)<=$(=max(Year))"}>}GLE15_DB) > sum({<Year={">=$(=max(Year)-4)<=$(=max(Year))"}>}GLE15_CR),
sum({<Year={">=$(=max(Year)-4)<=$(=max(Year))"}>}GLE15_DB) - sum({<Year={">=$(=max(Year)-4)<=$(=max(Year))"}>}GLE15_CR)
)