Calculate Percentage in VC

[Chris_Jeal]

Hi Community,

I have two columns:

Physical column: Total = 20,000
Virtual column: Total Declared = 5,145

I would like to create a VC with the percentage formula which at the minute I’m lead to believe is:

([Total Declared]/[Total])*100

although this formula produces a 0.00% where really I think it should be 25.7%.

Any ideas would be greatly appreciated.

Thanks in advance,
Chris.