Calculation on table columns

[#1]

Hi Community

I would like to work out a ration of the column "goal" and "actual YTD" to get a progress to target type figure.

Qlik is returning a kind of null value, is there a best practice way to do this?

Goal and actual YTD are in different but associated sheets.

Thanks!

[sunny_talwar · Accepted solution]

What is the expressions behind goal and actual YTD?

[#3]

Hi Sunny, I fixed it, thanks anyway