Does anyone know how to change the below formula to get the total column to total properly? That is to sum Nov + Dec?
I finally got the column to total (Nov and Dec) however now the total column does not total.
Here is the formula I used:
Data[Partner & Payment Type]
"Rate", [Forecast - Rate],
"Population", [Headcount Total],
"FFS", [Forecast - FFS Sum]
([Rate] * [Population]) + [FFS]