SET expression required

[yoganantha321]

Hi,

I have a data like as below

Budget	A Project	B Project	C Project
0.13	A
0.26		B
0.33			C
0.49	A
0.7		B

I need to display in a text object the sum of Budget of the  Project A and Project B that is 1.58 (excluding Project C)

How to achieve it...

Thanks in advance

Regards,

Yoganantha Prakash G P

[pooja_prabhu_n]

Hi,

You can try something like this:

=Sum({<[A Project]={'*'}-{''}>+<[B Project]={'*'}-{''}>}Budget)

Thanks,

Pooja

[Anonymous]

Hi Use this expression in text object

=Sum({<[A Project]={'A'}>}Budget) + Sum({<[B Project]={'B'}>}Budget)

[boraste-sagar]

Hi Yoganatha

try this

=Sum({<[A Project]={'A'}>}Budget) + Sum({<[B Project]={'B'}>}Budget)

[gawalimegha]

Hello Yoganantha,

Use simply this.

=sum( {<[A Project]={'A'}> + < [B Project]={'B'}>} Budget )

[yoganantha321]

Hi all,

I have given wrong data set.

Kindly find the new one

Budget	A Project	B Project	C Project
0.13	1
0.26		1
0.33			1
0.49	2
0.7		2
0.5	3
0.6		3

[yoganantha321]

Hi Pooja,

I have given wrong data set.

Kindly find the new one

Budget	A Project	B Project	C Project
0.13	1
0.26		1
0.33			1
0.49	2
0.7		2
0.5	3
0.6		3

[pooja_prabhu_n]

Hi,

Same expression works for this data set as well.

=Sum({<[A Project]={'*'}-{''}>+<[B Project]={'*'}-{''}>}Budget)

Thanks,

Pooja

[yoganantha321]

it is not working Pooja

[gawalimegha]

Hello Yoganantha,

Try this one.

=sum( {<[A Project]={">=1"}> + < [B Project]={">=1"}>} Budget )