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!
Decimal Quotient of 2 CountDistinct Formulas
Decimal Quotient of 2 CountDistinct Formulas
- Attachments
-
- Report (5).mrt
- (22.28 KiB) Downloaded 72 times
-
- Posts: 6271
- Joined: Tue Mar 20, 2018 5:34 am
Re: Decimal Quotient of 2 CountDistinct Formulas
Hello,
You should use the following expression:
{CountDistinct(Sheet1.CandidateID)/CountDistinct(Sheet1.ClientID)}
Thank you.
You should use the following expression:
{CountDistinct(Sheet1.CandidateID)/CountDistinct(Sheet1.ClientID)}
Thank you.