Dear all,
I need assistance with calculating revenue in my application.
I am experiencing some difficulties, as I know that the revenue is calculated as follows - sum(Sales) * sum (price).
In my data, I do not have field with prices and instead I have value, which is the price multiplied by the number of units sold already. There are of course different types of units sold and therefore different value in the value field.
So my question is - if I want to calculate Revenue based on the above fields, how should I do that?
Thank you in advance!
