topic Re: PROBLEM OF DIFFERENCE OF SUM in Francophones

PROBLEM OF DIFFERENCE OF SUM

bbmmouha — Mon, 02 Mar 2015 10:21:53 GMT

i have a problem and i need help

i'm a debutant

i have a dimension that contain products for exemple A B C D E F

i want to see the difference between the two products that he selected

for exemple if he selected A B

sum(A) - sum(b)

if he selected A C

sum(A) - sum(C)

thanks for help

Re: PROBLEM OF DIFFERENCE OF SUM

robert_mika — Mon, 02 Mar 2015 11:16:28 GMT

Text box expression

=sum(if(Name=textbetween(GetFieldSelections(Name,',')&',',',',','),Amount))-sum(if(Name=textbetween(','&GetFieldSelections(Name,','),',',','),Amount))

Script

Load * Inline

[

ID,Name, Amount

1,A,5

2,B,6

3,C,7

4,D,8

];

Re: PROBLEM OF DIFFERENCE OF SUM

robert_mika — Mon, 02 Mar 2015 11:18:34 GMT

File

Re: PROBLEM OF DIFFERENCE OF SUM

maxgro — Mon, 02 Mar 2015 12:10:54 GMT

maybe (in textbox)

=sum(if(Product=SubField(GetFieldSelections(Product,','),','), Amount))

sum(if(Product=SubField(GetFieldSelections(Product,','),',', 1), Amount))

Re: PROBLEM OF DIFFERENCE OF SUM

bbmmouha — Mon, 02 Mar 2015 13:30:25 GMT

thanks a lot

Re: PROBLEM OF DIFFERENCE OF SUM

jagan — Wed, 04 Mar 2015 02:08:46 GMT

Hi,

You can also try this using Set Analysis.

=Sum({<Name={$(=SubField(Concat(Name, '|'), '|', 2))}>} Amount) - Sum({<Name={$(=SubField(Concat(Name, '|'), '|', 1))}>} Amount)

Regards,

Jagan.