Hello all,
I have a report that is generated by a query. Inside that query is an expression that calculates for a percentage. It looks like this:
The target percentage number I am looking for with this report is 10% of the "TotalReceived". The format for the expression is percentage (of course)Code:[PercentVisInspected: IIf([TotalVisInspected]=0,0,[TotalVisInspected]/[TotalReceived])
I have been trying to get conditional formatting to make the output on the form show green bold if the number is 10% or higher and red bold if it is less than 10% but I am not smart enough.
Will someone please help me?