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
Solved! Go to Solution.
Thanks so much Marc, have a great one!!
User | Count |
---|---|
25 | |
25 | |
24 | |
21 | |
20 |