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]

What is the error you are getting?

If possible please share the sample app.

Thanks,

Pooja

[trdandamudi]

Please check your total and  it should be 2.68 and not 1.58. The below expression will give you 2.68 which is correct:

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

[snehalameya]

Hello,

Please try this.

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

Regards,

Snehal

[sasiparupudi1]

Try

=Sum(If(Len(trim([A Project])),Budget))+Sum(If(Len(trim([B Project])),Budget))-Sum(If(Len(trim([C Project])),Budget))

[vishus913]

Hi,

PFA the qvf, maybe this may work

Thanks

Vikas

[yoganantha321]

hi Vikas,

I cannot open the file. can you send the same in qvw file format

[poojashribanger]

Try this :

Sum({<AProject={"A"}>+<BProject={"B"}>}Budget)

[vishus913]

Hi i have no qvw ,

try this expression,

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

it worked well in the qvf

thanks

regards,

vikas

[yoganantha321]

thanks