Qlikview RangeSum function

[kiranb13]

Hi,

Can anyone help me in solving the below expression ?

RangeSum(Above(Sum((Sum (EST_Automate_TC)+Sum (EST_Manual_TC))/(networkdays([Analysis end Date Planned],[Test Completion date])), 0, RowNo())))

I need the below expression to be put under Rangesum function.

(Sum (EST_Automate_TC)+Sum (EST_Manual_TC))/(networkdays([Analysis end Date Planned],[Test Completion date])

[pradosh_thakur]

What is the reason for using rangesum in (Sum (EST_Automate_TC)+Sum (EST_Manual_TC))/(networkdays([Analysis end Date Planned],[Test Completion date]) ??

[sunny_talwar]

You have an extra Sum in there... try this

RangeSum(Above((Sum(EST_Automate_TC) + Sum(EST_Manual_TC))/(NetWorkDays([Analysis end Date Planned],[Test Completion date])), 0, RowNo()))