Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I've got a plan vs actual graph on one of my dashboards and I'd like to get the actual line to stop at the current month. The line currently has a formula as follows:
rangesum(Above(Sum ([Code End Month Count]),0,rowno()))
Can anyone help in the code or settings with a way to stop the line please?
May be try this:
If(Sum([Code End Month Count]) > 0, Rangesum(Above(Sum ([Code End Month Count]), 0, RowNo())))
or
If(Len(Trim(Avg([Code End Month Count]))) > 0, Rangesum(Above(Sum ([Code End Month Count]), 0, RowNo())))
Unfortunately this won't work as there is the odd item which gets done ahead of schedule.
Would you be able to share a sample showing your issue?