Error in SUM expression

[alwinsch]

Hi all,

I had an expression which worked out fine.

Sum({<Status = {'Gerealiseerd'}>}CommAuto)

but i want to add a new condition
.
Sum(Max(Load_month) , {<Status = {'Gerealiseerd'}>}CommAuto)

But it gives me an error.

Every month we load our data in a qvd file, with a variable Load_month,

So in my expression i want to make a sum with only MAX(Load_month)

Please can anyone give me a solution?

kind regards,

Alwin

[alexandros17 · Accepted solution]

Sum({$ <Status = {'Gerealiseerd'}, Month={'$(=Max(Load_month))'}>}CommAuto)

please verify that your field is Month and that its format is the same for Max(Load_Month)

hope it helps

[alwinsch]

Thanks,  it helped

but i do not have to use the first $ sign in your expression.