Expression to calculate walkin percentage

[Anonymous]

I want to calculate the  walkins growth  for the store. In general my formula should be as follows:-

total no of bills /walkins *100

Total No of bills (inv value as per my column name)

Walkins (walkins)

But when I am applying this in chart I am not getting values, so what would be the correct expression?

[sunny_talwar]

Do you mind sharing some raw data to show what you have and may be provide the expected output.... because it would be difficult to say anything without knowing what you have

[Anonymous]

Hi

I want bill count (circled in black) / walkins (circled in black) * 100

so i want column 1 /column3 * 100. so how to do that?

[sunny_talwar]

And you want this calculation in the same chart or a different chart?

[Anonymous]

same chart under heading conversion

[sunny_talwar]

So, what do you get when you add this?

Column(1)/Column(3) * 100

[Anonymous]

Hi

I want same values in Percentage?

[shiveshsingh]

From number tab, first check fix to integer and then select show in percent

[sunny_talwar]

I guess just change the expression to this

Column(1)/Column(3)

and use Number's tab for the formatting it as a percentage