Totals for Table in HTML

[sogloqlik]

Hi.

I have a report in HTML with table which has 4 columns in percentage format. I need to add Totals for each of the column. How can I achieve that? I tried to use <tfoot> with formulas but Is losses the Percentage format and shows decimal.

Regards,

Motty

[ajaykakkar93 · Accepted solution]

Hi,
use Num(...,'format')
to format your total in html it will work 

[sogloqlik]

Hi Ajay Kakkar

Where to add it? I tried in the formula but it doesn't work.

[andregas]

Hi @sogloqlik ,

You could try this:

text(num(<formula>, 'format'))

[sogloqlik]

My mistake.

Forgot small but very important thing: to put the format between '' 🤔🤕

Thank you both