Finding Percentage
Hello there,
I have two totals and I have to find the percentage of these two totals, but I can't write it properly. I just want to find out the result of [Total1] / ( ( [Total1] - [s1] ) -1)*100. How should I put this in the textbox?
This discussion has been closed.
Comments
Hello!
To resolve this issue, use explicit casting (double)[Total1] or the built-in function ToDouble([Total1]):
[IIf(([Total1] - [s1] - 1) == 0, 0, (double)[Total1] / (double)( [Total1] - [s1] - 1) * 100)](or
[IIf(([Total1] - [s1] - 1) == 0, 0, ToDouble([Total1]) / ToDouble([Total1] - [s1] - 1) * 100)]).