I have two types of Sales where my dash presents the total value in $ of each of these types, but I would like to show how much of the sale X (total sale) my sale Y represents, for example:
Sale X: 100 Sale and: 5 Sale and%: 5%
But when I create the calculated field Sale y% (logically below), I get the value of 0%
Logica venda y: 1 - ([SellY] / VendaX)
NOTE: I already checked the decimal places, the type of number displayed (percentage)
Any solution?