Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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])
What is the reason for using rangesum in (Sum (EST_Automate_TC)+Sum (EST_Manual_TC))/(networkdays([Analysis end Date Planned],[Test Completion date]) ??
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()))