# Trying to get proper decimal place in report

**URL:** <https://forum.inductiveautomation.com/t/trying-to-get-proper-decimal-place-in-report/74468>\
**Category:** Ignition\
**Tags:** ignition78, vision\
**Created:** [June 2, 2023, 4:17am UTC](https://forum.inductiveautomation.com/t/trying-to-get-proper-decimal-place-in-report/74468 "2023-06-02T04:17:39Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![andrews](https://avatars.discourse-cdn.com/v4/letter/a/898d66/32.png) [@andrews](https://forum.inductiveautomation.com/u/andrews)\
**Post date:** [June 2, 2023, 4:17am UTC](https://forum.inductiveautomation.com/t/trying-to-get-proper-decimal-place-in-report/74468/1 "2023-06-02T04:17:39Z")

</div>

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.

```auto
SELECT wastewaterlog.FlowRate / 10 AS FlowRate,
  wastewaterlog.GrandTotal,
  wastewaterlog.Past15MinFlow / 10 AS Past15MinFlow,
  wastewaterlog.t_stamp
FROM wastewaterlog

```