Hello all!
So I have a field that gives me the difference of 2 other fields, and it looks like this in design view:
Budget vs Actual: Sum(([Actual Amount]-[Budget Amount]))
In the field next to this one, I need to divide the difference (which the above field shows in my query) by budget amount and then I need it to show up in percentage form where it only shows me amounts
>10% or < -10%
This sounds excruciatingly difficult to me, especially since I'm a beginner. I hope someone can help me with this one!
Thanks,
Nani
So I have a field that gives me the difference of 2 other fields, and it looks like this in design view:
Budget vs Actual: Sum(([Actual Amount]-[Budget Amount]))
In the field next to this one, I need to divide the difference (which the above field shows in my query) by budget amount and then I need it to show up in percentage form where it only shows me amounts
>10% or < -10%
This sounds excruciatingly difficult to me, especially since I'm a beginner. I hope someone can help me with this one!
Thanks,
Nani
