Convert to number

[Muzekker_Vatan]

Hi,
I have a formula as below. The formula is taking date from GS.
CONCATENATE(SUM(SELECT(UKF[AVAILABLE KG],[DATE]>TODAY()-365)),” kg”). This is a VC in my App.
I am getting the result as 5506309 even the column type is number. How possible is to convert it as number as 5,506,309.00?
Thanks in advance.

[TeeSee1 · Accepted solution]

try

DECIMAL(SUM(SELECT(UKF[AVAILABLE KG],[DATE]>TODAY()-365)))

Concatenating a number/decimal with a text string ("kg") gets you a text data..

[Muzekker_Vatan]

Dear TeeSee1,
Thanks for your guide. Appreciate