Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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
Thanks, it helped
but i do not have to use the first $ sign in your expression.