How to get the addition in third column

[abc_18]

Hi,

in attached image I have column a and b

column a expression is =Max({<CSMmilestonename={'Build'}>}SprintNo)

and column b expression is =Min({<CSMmilestonename=-{'Build'}>}CSMsprints1)

in third column i need to get the addition of these two

that is 54+1+6+1,  '54' from column a

and '1+6+1' from b.

please help

[Anonymous]

Now I see it,

a and b are dimensions...

So you'll need a synthetic dimension (valuelist())  or precalculate it in script.

Please prepare a qvw sample.

[abc_18]

Hi Robin,

column a and b are expressions.

Thanks

[Anonymous]

please prepare a sample...

[antoniotiman]

I am sorry, I need Your App.

However try

Sum(Aggr(Sum(Alt(a,0)+Alt(b,0)),[Capability Name]))

[abc_18]

Attaching the Qvw sample, here column 1 and column 2 are dimensions, but in original post these are expressions.

[Anonymous]

It is working for me.

Try putting

Set NullInterpret = '';

in your script

[abc_18]

Fayez you should get sum as 62

sum(a)+sum(b) should be 62 for capabilty name

[tyagishaila]

Sum(Total Aggr(Sum(a)+Sum(b),CapabilityName))

[abc_18]

Getting '0' values in that column.

[tyagishaila]

Create variable for a and b values

and then try it

Sum(Total Aggr($(vA)+$(vB) ,C_Name))