How to get Ratio % not exceed 100%

[#1]

Hi Guys,

i need to calculate 2 fields and their ratio must never be above 100%

e.g:

FieldA = 3446

/

FieldB = 943

Ratio: 365%

so i want it to be 100%

Thanks.

[kuczynska]

Hi Thabiso,

You can apply simple IF condition, something like the below:

IF(FieldA >= FieldB, 1, FieldA/FieldB)

and format the number as % in the numbers tab. Hope that helps.

[simenkg]

Rangemin(FieldA/FieldB,1)