It will be easier if you can provide a sample workbook or sample data.
This is exactly what I needed. I do have two additional questions -
1) why the -1 at the end of the calculation?
2) If i wanted to change turn this calculation into point difference. I would use the same calculation you provided
how or where do I put in the multiply by 100 to get a whole number rather than a percent?
to your 1st question, it is the same as below equation:
(Sum([Revenue]) - sum([Revenue Planned]))/sum([Revenue Planned]) = Sum([Revenue]) /sum([Revenue Planned]) - 1
to your 2nd question, if you want the whole number rather than a percent, please use (100*[Revenue]/[Revenue Planned]) and format as number, not percentage.
Hope this helps.
If my answer sloves your question, please mark my answer as eirther corrrect or helpful to close the thread.
Please find the below attachment, if it working then marked as correct and helpful.
1.Right Click On Amount->Quick table Calculations->Percent Difference.
Here i am attached Screen shots for detail only ,You can follow above step directly.
Amar D. Savale
Book1_v10.5.twbx 27.3 KB