Both of these values are being pulled from the detailed section.
Example Data: Actual Amount=266,754.00 and Contract Amount =241,195.00 this calculation should come out too 1.105 which is 110.5%
It is in the detail section of my report. I tried
=[contract amount]/[Actual amount]
but this just gave me 100% percent values all the way down...not the correct calculation.
Hi....hope someone can shed some light for me.
I have a report and I am trying to find out the percent over contract amount.
This is the formula I am using, and I am getting the wrong data.
=Sum([Contract Amount])/([Actual Amount])
example.... for contract amount 241,195.00 and actual amount...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.