How can I calculate an estimate that outputs two numbers in the same field?

Hello @zxpw

Thank you very much for using our plugin.

Yes, that’s possible. Assuming the number field is the fieldname1, you can implement the equation as follows:

CONCATENATE('$',PREC(fieldname1*5,2),' - $', PREC(fieldname1*10, 2));

The “PREC” operation PREC(X,Y) rounds the number X with Y decimals, and “CONCATENATE” concatenates its parameters.

Best regards.