Forum Discussion
Comparing current data with a baseline information which has no raw data source
Hi, I need to compare my current report with a baseline data which do not have raw data. My current report which is in a pivot (matrix) format is as per below. Basically, the ab...
You can use SUM. As long as the baseline <subs_calc> value is unique, it will be be a SUM of 1 value.
Hi,
When I use SUM, it does not present the numbers correctly either. The Subs_Calc is unique but when i use this formula
TAT Difference = AVERAGE(FBL1N_JULY_WORKING[Invoice_Date_to_Submission_Date_Calc]) - SUM(Sheet1[TAT])
The results is incorrect.
Sheet1 is basicaly the baseline data and Invoice_Date_to_Submission_Date_Calc is "TAT" column from current data.