Decimal Quotient of 2 CountDistinct Formulas

[tourquse]

Hi,

I would like to divide two CountDistinct formulas together and show the result to 2 decimal places. I have set the TextBox text format to Number with 2 decimal places. However the result is rounding down to the nearest whole number, showing the 2 decimal places as zeros.

This is the formula I am evaluating:
{CountDistinct(Sheet1.CandidateID)}/{CountDistinct(Sheet1.ClientID)}

I have attached an example.

Thanks!

[Lech Kulikowski]

Hello,

You should use the following expression:
{CountDistinct(Sheet1.CandidateID)/CountDistinct(Sheet1.ClientID)}

Thank you.