Year to go calculation
Has anyone worked out a Year to Go calculation (amount of spend that is left in the year)? I thought it was as easy as
YEARVALUE(Amount) - YEARTODATE(Amount)
But this doesn't work on a versioned line item with a switchover that happens during the year. Full year for the actuals part is different to full year from the version part.
In this case the switchover for the version is Oct 23.