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.
Solved! Go to 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..
try
DECIMAL(SUM(SELECT(UKF[AVAILABLE KG],[DATE]>TODAY()-365)))
Concatenating a number/decimal with a text string ("kg") gets you a text data..
Dear TeeSee1,
Thanks for your guide. Appreciate
User | Count |
---|---|
36 | |
31 | |
30 | |
20 | |
17 |