Calculate Number of Sales before the Discount Value

[Brownie]

I wanted to ask the expression used to calculate the number of sales that occurred before and after discount on a certain product. Also, how do i convert my discount value into percentage? 

[Mark_Little]

HI @Brownie 

For prior to discount i would be looking to do something in script to flag where the discount happened, then use that in the analysis, but hard to suggest more as i am not sure how you a grouping the data for the discount.

As for the discount as percentage, edit the table and find the column in question set number formatting to number and then format to the percentage.

If it is a dimension then i would do it in script with the NUM() function