MIP Ideas Portal

Ability to have multiple formulas in the same variance column

Currently the "Current Period Change" and "Current Year Change" columns only have one formula whereas it takes the Current Year data and subtracts it from the Prior Year data to create the variance.  For Revenue, if the Current Year is more than the Prior Year than it creates a positive variance which is correct.  However, on the expenses if the Current Year is more than the Prior Year it also creates a positive variance, which is wrong.  If the expenses are higher in the Current Period/Year it should create a negative variance.  For some reason the "Budget Variance" columns do this correctly.  They have one formula for Revenue and one formula for Expenses.  But, I am being told this cannot be done for the variances to Prior Year even if I was to try and create my own column.

  • Guest
  • Sep 1 2017
  • Attach files