Problem using p() and e() in set analysis

marcel_olmo — Fri, 22 Sep 2017 17:30:10 GMT

Hi guys,

I'm trying to do an example of the excluded function e() in set analysis, but I can't make it work.

I have a simple table with two fields : Code and Amount.

The total amount is 1.601.985

So if I filter for amounts bigger than 800 and lower than 1400 :

The current amount is 521.905

And the excluded amount would be the substracion of the two above : 1.080.080

I'm trying to get the excluded amount with the following formula :

sum( {$< Code = E({1<Code= {'$(=vConcatSelectedCodes)'} >})>} Amount)

where vConcatSelectedCodes is concat(distinct chr(39) & Code & chr(39) ,',')

And this is what I get :

Could somebody tell what I'm doing wrong?

In case you need, I've attached the qvw and qvd file.

Regards, Marcel.

Re: Problem using p() and e() in set analysis

antoniotiman — Fri, 22 Sep 2017 20:03:59 GMT

Hi Marcel,

try this

Sum({1<Code=E(Code)>} Amount)

Regards,

Antonio

marcel_olmo — Mon, 02 Oct 2017 16:25:58 GMT

Thanks Antonio, that was it!

Regards, Marcel.