cancel
Showing results for 
Search instead for 
Did you mean: 

Calculated column as difference

JefB
Active Contributor

Hi Experts,

I have a simple SAC report (on an acquired/planning model) showing in columns the 'current day' and 'current day-1', using dynamic range (based on system date). But I want to show a third calculated column showing the Subtract (difference), like this:

This works today, but tomorrow system date will change, and I will lose this column calculation due to incorrect formula reference. This calculated column has to work across all our accounts/measures.

Is there a solution?

Accepted Solutions (0)

Answers (0)