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?

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)]).

This discussion has been closed.