how to write dynamic expression

[kunkumnaveen]

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)

                                                                                or

                                     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

[tresesco · Accepted solution]

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

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

[YoussefBelloum]

Hi,

try it like this:

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