Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All
I have below expression work fine :-
Sum( {<eXP={eXP}>} Amount*-1/1000)
Below is the expression which i want to compute TOTAL for the above expression , IT Also work fine, as shown in table 1 :-
Sum(ALL {<eXP={eXP}>} Amount*-1/1000)
Now i have expression below , which convert all the currency to SGD:-
Sum( {<eXP={eXP}>} Amount*-1/1000)/Rate
when i modify the above expression with compute Total as below :-
Sum(ALL {<eXP={eXP}>} Amount*-1/1000)/Rate
it cannot work as shown in Table 2.
Can some one advise me ?
PAul
You can try this..
Sum(TOTAL Aggr(Sum( {<eXP={eXP}>} Amount*-1/1000)/Rate,SOURCE))
my QV Doc
Hi Paul,
I think your expression seems to be working fine..
i separated the expression and gives the same result..
Hi Settu
Thank you for your reply.
You can try this..
Sum(TOTAL Aggr(Sum( {<eXP={eXP}>} Amount*-1/1000)/Rate,SOURCE))
HI Settu
thank you very much
paul
try in this way
Sum(ALL {<eXP={eXP}>} (Amount*-1)/1000)/Rate
Hi Gupta
I already got the solution , after add Aggr it work fine. As I am using V9 , this is the work around.
Paul
Sent from my iPhone
Hi Gupta
Correct expression as below from Settu :-
Sum(TOTAL Aggr(Sum( {<eXP={eXP}>} Amount*-1/1000)/Rate,SOURCE))