Set analysis for addition of two different values

[#1]

Hi,

I have two different values A & B having integers as value.

How can I add these two values using set analysis ?

Please help

[sujeetsingh]

I dont get why are you adding it in set analysis???

[nirav_bhimani]

Hi,

Can you elaborate in detail with eg..

Regards,

Nirav Bhimani

[#4]

Hi,

There is a WBS and under every WBS there are diff activities.

Budget is decided at WBS level and not at activities levle.

Cost is present at WBS as well as activities level.

Now i want available i.e. budget - cost.

I am using a pivot table. When i calculate available for activities , it shows wrong data as budget is not decided at activity level.

So i am trying to put a text box that should be shown by default for every WBS to show the avilable.

If i use "IF" ....it will only show numbers when dat particular WBS is selected.

So i want to use set analysis for dat.

Thanks in advance

[sujeetsingh]

Bla Bla!!!!!!  Got confused...

[#6]

Hi Nirav,

i have dis expression :- =sum({<WBS={'123456'}>}(WKGBTR))

Now i want to add WKGBTR as well as WKGBTR_NEW using set analysis with the same condition.

Thanks in Advance

[nirav_bhimani]

Hi,

I didnt get you, You want to add the WKGBTR & WKGBTR_NEW with same condition,then

sum({<WBS={'123456'}>}(WKGBTR)) + sum({<WBS={'123456'}>}(WKGBTR_NEW ))

If possible then share a  demo app for the same.

Regards,

Nirav Bhimani

[#8]

Hi,

I tried but its not wrking

Regards,

[udit_kumar_sana]

Hi,

You can also try this for your budget - cost calculation at WBS level:

sum( <WBS>budget)-sum(<WBS> cost).

Regards,

Udit