I have a report that has a running total of 'number of observations' using the following formula:
if {model_.Node numbers} <> 1 then {#RTotal Cum Mail} else {model_.Number of observations}
This ensures that node 1, which will always be the last value, displays its actual value and not the cumulative total. This works fine but I need to plot the results of this formula on a scatter graph against another formula of the same type. However, due to my formula referring to the {#RTotal Cum Mail} running total formula I am unable to select the formula to use in my graph?!
I also require a zero value and a line of best fit to be included if possible.
Any ideas?
if {model_.Node numbers} <> 1 then {#RTotal Cum Mail} else {model_.Number of observations}
This ensures that node 1, which will always be the last value, displays its actual value and not the cumulative total. This works fine but I need to plot the results of this formula on a scatter graph against another formula of the same type. However, due to my formula referring to the {#RTotal Cum Mail} running total formula I am unable to select the formula to use in my graph?!
I also require a zero value and a line of best fit to be included if possible.
Any ideas?