machumpion
Registered User.
- Local time
- Today, 09:50
- Joined
- May 26, 2016
- Messages
- 93
I have a sales dataset which includes alot of negative values in the 'order' field which represents discounts applied.
I wish to calculate the gross amount of sales (ignores discounts). How can I quickly do this without putting the Order field in Report Filter and unchecking all the negative values before putting it into the Values field?
I wish to calculate the gross amount of sales (ignores discounts). How can I quickly do this without putting the Order field in Report Filter and unchecking all the negative values before putting it into the Values field?