topic Re: Adding calculated row in Table in Qlik Automate

Adding calculated row in Table

CBoardy — Mon, 27 Feb 2023 10:25:18 GMT

Hi All,

I have a table with multiple rows including Sales and a Margin row, I want to add a calculated row which will be % of Margin/Sales. Can someone push me in the right direction, I'm not sure if this is possible or how to actually do this

Any help is much appreciated

Re: Adding calculated row in Table

rui24 — Mon, 27 Feb 2023 13:16:20 GMT

Hi @CBoardy

You can try this expression on the table adding a new measure expression

=(Margin/Sales)*100&'%'

The "*100" will transform in percentage and the "&'%' will add the symbol of percentage to the valor, if you don't want you can just use =(Margin/Sales) and in the option format number to percentage