Archive for June, 2010

is missing?

June 17, 2010

Simple arithmetic may not work sometimes when you are after just a simple variation. Please see the attached report screen-shot: 

A simple subtraction will not work for you to calculate the variance between Actual data and Prior year data when one of them missing.

 If we update the simple formula [Actual]-[Prior] with a nested if statement we can check the missing numbers:

 

See the correct results both in rows and also in total:

Advertisements