AC Formatter reading numbers as text (therefore formatting options do not appear or fail)

Wappler Version : 4.12
Operating System : Mac
Server Model: Node
Database Type: Postgres
Hosting Type: Docker local

Expected behavior

What do you think should happen?

Create a DB Query SC that outputs numbered data, in this case i’m using ‘Aggregate’ in the DB and ‘sum’ is the SUM Aggregate and ‘count’ is a COUNT aggregate.

The original field type for ‘sum’ in the DB is decimal. The naming ‘sum’ is an alias of the real field name.

I should then be able to use the AC Data picker to format that number (e.g. removing decimal places for the UI).

Actual behavior

What actually happens?

Data Picker views the number output as an ‘A’ and therefore only gives me text formatting.

See query output in AC:

Both here should actually appear as a number.

However when I click on the number field ‘sum’ and use the magic wand:

Screen Shot 2021-07-13 at 4.05.23 pm354×721 13.7 KB

It displays the type as ‘text’.

If I change type to number - the output on the page doesn’t perform (blank) whereas if I leave without formatting it displays on page.