how to write dynamic expression

kunkumnaveen — Thu, 09 Nov 2017 10:39:40 GMT

Hello All,

when the expression is like below it is working(value=85 correct)

Expression:

sum({<SCOPE={'YES'},NUMBER={'030'}>}total VOLUME)

I tried to make expression dynamic then it is not working(value=0 incorrect)

1) sum({<SCOPE={'YES'},NUMBER={"$(=max(NUMBER))"}>}total VOLUME)

2) sum({<SCOPE={'YES'},NUMBER={'$(=max(NUMBER))'}>}total VOLUME)

Both the expressions are not working ,

LOAD

right("/BIC/A_CDAYS",3) as NUMBER

FROM [lib.qvd]

(qvd);

kindly suggest how to make it dynamic

thanks

Re: how to write dynamic expression

tresB — Thu, 09 Nov 2017 10:44:19 GMT

It could be because of the number format. Try like:

sum({<SCOPE={'YES'},NUMBER={"$(=Num(max(NUMBER),'000')"}>}total VOLUME)

YoussefBelloum — Thu, 09 Nov 2017 10:44:49 GMT

Hi,

try it like this:

sum({<SCOPE={'YES'},NUMBER={$(=max(NUMBER))}>}TOTAL VOLUME)