Expresion wont work!

[#1]

Im creating this Expressions and i cant get it to work.

sum({$<Offerte.Jaar={$(=Only(Offerte.Jaar))}>} ($(vNettoBedrag) )

The variable is like this : sum(OfferDetail.NETSALESAMOUNT) + sum(OfferMisc.NETSALESAMOUNT)

Any help?

[hector]

Hi,

i think the problem is that you can't use sum( sum() ...), except if you use aggr() before the main sum()

check your formula, if this is valid change for

sum({$<Offerte.Jaar={$(=Only(Offerte.Jaar))}>} $(vNettoBedrag) )
And
vNettoBedrag = OfferDetail.NETSALESAMOUNT + OfferMisc.NETSALESAMOUNT

rgds

[#3]

Hey Hector thank you for your quick responce.

Using sum( sum( is indeed the problem. However if i change my variable to your suggested code i get a wrong result. The numbers go minus and one number skyrockets

[#4 · Accepted solution]

You will have to enclose it in an aggr like follow:

aggr(sum(OfferDetail.NETSALESAMOUNT) + sum(OfferMisc.NETSALESAMOUNT),Dimension1, dimension2)

Replace the Dimension1 etc with the dimensions you use in the chart.

This can then be used to sum with the other sum function.

Try this and when you get the result you can change the sums for a variable, remember that variables can return the string strange so double check it is expanded correctly.

//John

[#5]

Works Perfect Thank you!