Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi guys,
Someone know what's up in this expression?
Ceil( Max( Aggr( Sum({1<Currency = {$(=GetFieldSelections(Currency))}>}Warehouse.Money) ,SubRegion ,Calendar.Week)) ,0.1)
I don't understand a mistake in Ceil =(
Thank you!
Hi,
This expression works properly, there is no issue with the parameter 0.1 to Ceil()
Ceil( Max( Aggr( Sum({1<Currency = {$(=GetFieldSelections(Currency))}>}Warehouse.Money) ,SubRegion ,Calendar.Week)) ,0.1)
It will round off to the next given level, assume that your expression returns 3.88 and 0.1 will 3.9
I think you forgot to give = in variable. Give = infront of the expression.
Regards,
Jagan.
Have you looked at
Max( Aggr( Sum({1<Currency = {$(=GetFieldSelections(Currency))}>}Warehouse.Money) ,SubRegion ,Calendar.Week))
to see what it returns?
Hi,
Try to add " on your set analysis like :
Ceil( Max( Aggr( Sum({1<Currency = {"$(=GetFieldSelections(Currency))"}>}Warehouse.Money) ,SubRegion ,Calendar.Week)) ,0.1)
Aurélien
Ceil( Max( Aggr( Sum({1<Currency = {"$(=Concat(Chr(39) & Currency & chr(39),','))"}>}Warehouse.Money) ,SubRegion ,Calendar.Week)) ,0.1)
Thank you for all responses!
My expression working properly, but when I want to set a variable with my expression,I get an error in Ceil function as when I delete ',0.1', working properly!
Regards!
It should work. Can you post sample app with Ceil issue
Hi,
This expression works properly, there is no issue with the parameter 0.1 to Ceil()
Ceil( Max( Aggr( Sum({1<Currency = {$(=GetFieldSelections(Currency))}>}Warehouse.Money) ,SubRegion ,Calendar.Week)) ,0.1)
It will round off to the next given level, assume that your expression returns 3.88 and 0.1 will 3.9
I think you forgot to give = in variable. Give = infront of the expression.
Regards,
Jagan.
Hi,
If you got the answer please close this thread by giving Correct Answer to the useful post, so that it would be helpful for others.
Regards,
Jagan.