Virtual column not showing in email

[theone]

I have included a bot that sends me an email whenever there's en edit on the app, and in the email body I have included the virtual column. The virtual column is 'Final Ratings' of percent type, but it shows 0% in the email while it shows the correct value in the app.
Does the data in virtual columns not show in emails?

[AleksiAlkio]

What is your formula in your virtual column?

[theone]

(
NUMBER([column 1]) +
NUMBER([column 2]) +
NUMBER([column 3]) +
NUMBER([column 4]))/16

@AleksiAlkio 

[AleksiAlkio]

The result is a number (0) because you are dividing number with a number. Use 16.0 instead of 16.

[theone]

Tried this, but it didn't work, final ratings is still displayed as 0% in the email although in the app it has been showing the correct percentage.                               My individual columns i.e. column 1, column 2 etc are of enum list type with base type as decimal, the enum list has four values [1,2,3,4].

[AleksiAlkio · Accepted solution]

Instead of NUMBER(), use INDEX([Col1],1) so the result would be calculated with decimal/number.

[theone]

Thank you so much, this worked

[AleksiAlkio]

You're welcome!