I was having a review of the wonderful sales pacing dash and thinking about targets and forecast.
I'm wondering if/how people have gone about forecasting a final position based on prior performances and what they used in formulas.
eg:
I was keen to play with sames pacing based on an adjusted forecast target.
Can you tell I'm keen for v16 and predictive modeling?
Can you provide more detail of what you have in place and does it render the RSUM without doing a forecast? Images encouraged :)
Eg. Do you have RSUM ( [Ticket Paid Amount] ) or RSUM ( [Total Ticket Paid Amount] ) or RSUM ( SUM ( [Ticket Paid Amount] ) )
RSUM ( [Ticket Paid Amount] )
RSUM ( [Total Ticket Paid Amount] )
RSUM ( SUM ( [Ticket Paid Amount] ) )
That's what I get if I use RSUM instead of SUM
Perfect! Thank you. Yes, so given a numeric value like SUM ( [Ticket Paid Amount] ) (which might also look like [Total Ticket Paid Amount] ), the Running Sum function, RSUM(), should surround that value like RSUM( SUM ( [Ticket Paid Amount] ) ).
SUM ( [Ticket Paid Amount] )
[Total Ticket Paid Amount]
RSUM(
SUM ( [Ticket Paid Amount] ) ).
Yahoo! Thank you - that fixed it!