Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello everyone,
Can we make work a set analysis with a function inside ??
This is my expression :
sum({<Soldes.num_Mois={'10'}>}Soldes.solde)
It works perfectly but I would like the 10 ( the number of the current month to be calculated automatically), so I've tried:
({<Soldes.num_Mois={ Num(Month(Today())) }>}Soldes.solde)
But there is an "error modifier ad hoc element list"
I have also tried :
({<Soldes.num_Mois={ "Num(Month(Today()))" }>}Soldes.solde)
The Expresision is "ok" but the result is not what I expect, the result is as if I hadn't put any set analysis...
Do you know what is wrong in the syn,tax?
Thank you for your help
Hi Laura,
Have you tried this?
$(=max(Month(Today())))
Instead of
"Num(Month(Today()))" .
Miguel
add a variable for Num(Month(Today()) and then replace it in the expression with the variables
I have also tried it and it doesn't work as well
Hi Laura,
Have you tried this?
$(=max(Month(Today())))
Instead of
"Num(Month(Today()))" .
Miguel
Try
({<Soldes.num_Mois={ $(Num(Month(Today()))) }>}Soldes.solde)
Thank you, it works !!
But I don't understand why 😕
Can you explain me how the "max" make it work ?
yes. please do. seems like there would only be one max month to todays month. Was it the addition of the " = " that made that work?
Hi Laura,
Please read this paper, hope it help you understand the solution:
Thanks for marking my answer as the correct one
Have a happy weekend