simple arithmetic on column values

[dreweezy]

My syntax is probably wrong but I am trying to achieve a value using addition and subtractions on other columns in Qlik Sense.

My syntax is:        sum(([revenue]) - (([cost] * [tax])))

I am trying to achieve the values in the 'Sum([netincome])' values. But running my syntax I am getting the results in the 'testing' column.

[sunny_talwar · Accepted solution]

Is Tax in % or is it dollar amount? Cost * Tax (2000*1000) = 2,000,000 and subtracting this from 10,000 gives -1,990,000... which is what you see...

[dreweezy]

Sunny, I overlooked this problem... thanks for your prompt reply I realized soon after.