Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Try
Alt(a,0)+Alt(b,0)
using this formula I am getting column 'a+b' data, but my b column data should come from 1 and result should be
'54+1+6+1'
54 is for Build from column a
and 1+6+1 is for '=-Build' from column b
Try like this:
=Sum(Aggr(Max({<CSMmilestonename={'Build'}>}SprintNo), CSMmilestonename))
=Sum(Aggr(Min({<CSMmilestonename=-{'Build'}>}CSMsprints1), CSMmilestonename))
For column a and b by using above expression as mentioned in my original post I am getting correct .
how to get addition in third column that is one level down.
output should be 54+1+6+1=62
RangeSum(Top(Sum(a+b),1,NoOfRows()))
or provide sample data
rangesum(a,b)
Hi Shikha,
The problem here is due to nulls. If you add null to any value, the result will be a null.
So use something like this
(IF(isnull([Column a]),0,[Column a])+
IF(isnull([Column b]),0,[Column b])
) as Column C
Hi Antonio,
Not working using Rangesum function.
Attaching sample file, Please check
Hi Fayez,
Not getting proper output ,attaching sample data.
Output should be sum of both column