Limit to 2 decimal places

[crmclients]

Hello!

I see this in the documentation for setting a decimal

but I can't figure out how to wrap it around my ifThen statements that are currently giving me 12 places: where testPcd=90.804597701149 when the drop down (ESI Post, PSI Post, PSA Post....) is selected

ifThen(testType == 'ESI Post', testPcd = (testScored/87)*100
);
ifThen(testType == 'PSI Post', testPcd = (testScored/82)*100
);

At the end of the list (there are actually 8 options in the drop down that can affect the calculation, I am showing just 2 above) and also tried

By themselves, the equations work great (once I figured out I needed to use the FLOAT type!)... Just need to limit the decimals. I know it's something very basic I am not aware of, thanks in advance

[alexisc]

https://docs.espocrm.com/administration/formula/#numberformat

[crmclients]

may I wasn't clear, here is what the documentation says

• number\format(2.666667, 2) - results 2.67

can someone help me with the actual statement i need to construct?

• I see this in the documentation for setting a decimal can't figure out how to wrap it around my ifThen statement

[Jakub Grufik]

Try this
ifThen(testType == 'ESI Post', testPcd = number\format((testScored/87)*100, 2)
);

[crmclients]

Thanks Jakub! I was missing the the *100 and a )
This worked perfectly

To anyone who might need, after updating the Formula, I did a MASS UPDATE on the Description field (not really using it so i just added a ".") and all records recalculated to 2 decimals

Thanks again!