Answered

How to put dollar $ sign in a html table which may have some rows are empty.

Like (0) Share

Report

Posted on 13 Feb 2024 12:41:00 by sam123123123

Hello All,

I would like to ask how to add a dollar sign to an HTML table. I have seen some methods, like formatnumber, on the forum; but, it doesn't work for my flow as my inputs are string. And then I changed it to INT, but it didn't work.

Hope can get some help. Really apprecaiate

Flow:

HTML Table

When use formatnumber, it fails due to string value.

and then use "If empty" to bypass it but it also doesn't work.

Finally, when I converted it to INT, it also doesn't work.

Categories:

Business Process Flows

All responses (6)

Answers (1)

sam123123123 on 13 Feb 2024 at 15:09:42

Like (0)

Report

Re: How to put dollar $ sign in a html table which may have some rows are empty.

Ok now, it works. Thanks !!
ManishSolanki 15,085 Super User 2025 Season 1 on 13 Feb 2024 at 15:06:52

Like (1)

Report
Re: How to put dollar $ sign in a html table which may have some rows are empty.

Hi @sam123123123

There is syntax error, you have forgotten to close the if formula. Pls use the below expression:

if(empty(item()?['outstanding date']),'',concat(item()?['outstanding date'],'Days'))

If this helps & solves your problem, please remember to give a 👍 and accept my solution as it will help others in the future.
sam123123123 on 13 Feb 2024 at 14:58:07

Like (0)

Report

Re: How to put dollar $ sign in a html table which may have some rows are empty.

Thanks Manish Solanki,

it works. Can I ask one more quetsion. How can I ask add "days" in the outstanding column.
like 373Days.

I use the "concat', but it shows this, and then I use if(empty(item()?['outstanding date']),'',concat(item()?['outstanding date'],'Days'), it doesn't allow me to use this formula.
Verified answer

ManishSolanki 15,085 Super User 2025 Season 1 on 13 Feb 2024 at 14:30:25

Like (1)

Report
Re: How to put dollar $ sign in a html table which may have some rows are empty.

Hi @sam123123123

The input also contains decimal number, so we need to use float function:

if(empty(item()?['Balance']),'',formatNumber(float(item()?['Balance']),'$#.#'))

If this helps & solves your problem, please remember to give a 👍 and accept my solution as it will help others in the future.
sam123123123 on 13 Feb 2024 at 14:20:47

Like (0)

Report

Re: How to put dollar $ sign in a html table which may have some rows are empty.

Hello, Manish Solanki

Thanks for the solution. But, it seems it still has an error .
ManishSolanki 15,085 Super User 2025 Season 1 on 13 Feb 2024 at 13:45:02

Like (1)

Report
Re: How to put dollar $ sign in a html table which may have some rows are empty.

Hi @sam123123123

Pls use the below expression for 'Balance' column:

if(empty(item()?['Balance']),'',formatNumber(int(item()?['Balance']),'$#'))

just replace the column name in above expression for other currency columns.

If this helps & solves your problem, please remember to give a 👍 and accept my solution as it will help others in the future.