Virtual columns

[cuadromoreno]

A simple thing but turn out complicated. I just want the rate of bottles that are in store so i created a virtual column but it shows it for a second with the right number but then it disappears and stays in zeroes.

(SUM(SELECT(Mov[Contains_qtty], [Income_v].[Contains_lus] = "7"))/
SUM(SELECT(Income[Contains_qtty], [Contains_lus] = "7"))) * 100

I didn't find any topic here about this. Help appreciated! , thanks

[Marc_Dillon · Accepted solution]

Fix for expression giving 0% or missing decimal pa... - Google Cloud Community

[cuadromoreno]

Thanks so much Marc, have a great one!!