Trying to get proper decimal place in report

Ignition
,
1

So I have a report with two parameters which are floats. 2-3 digits long. I need a decimal point before the last digit for it to render properly. But I am having trouble formatting it.

I try formatting but it doesn't put the decimal before the last digit.

Thanks in advance !

Figured it out. This is how I query the DB and it works.

SELECT wastewaterlog.FlowRate / 10 AS FlowRate,
  wastewaterlog.GrandTotal,
  wastewaterlog.Past15MinFlow / 10 AS Past15MinFlow,
  wastewaterlog.t_stamp
FROM wastewaterlog
4 Likes