Ceil - Error: Garbage after expression : ","

[#1]

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!

[m_woolf]

Have you looked at

Max( Aggr( Sum({1<Currency = {$(=GetFieldSelections(Currency))}>}Warehouse.Money) ,SubRegion ,Calendar.Week))

to see what it returns?

[Aurelien_Martinez]

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

[anbu1984]

Ceil( Max( Aggr( Sum({1<Currency = {"$(=Concat(Chr(39) & Currency & chr(39),','))"}>}Warehouse.Money) ,SubRegion ,Calendar.Week)) ,0.1)

[#5]

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!

[anbu1984]

It should work. Can you post sample app with Ceil issue

[jagan · Accepted solution]

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.

[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.