This content has been marked as final.
Show 7 replies

Re: How to calculate Discount Value
Dave Lau Nov 14, 2017 3:57 AM (in response to prachi dhok)Hi prachi
plz provide some sample data

Re: How to calculate Discount Value
prachi dhok Nov 14, 2017 4:13 AM (in response to Dave Lau)Sales Quantity Discount Profit Shipping Cost 2309.65 7 0% 762.1845 933.57 3709.395 9 10% 288.765 923.63 5175.171 9 10% 919.971 915.49 2892.51 5 10% 96.54 910.16 2832.96 8 0% 311.52 903.04 2862.675 5 10% 763.275 897.35 I need to calculate discount value(for eg. second row sales value is 3709.395 and discount 10% so want to find discount value)

Re: How to calculate Discount Value
Dave Lau Nov 14, 2017 4:24 AM (in response to prachi dhok)I think this is fine
=Sum(Sales * Discount)



Re: How to calculate Discount Value
Arvind Patil Nov 14, 2017 4:12 AM (in response to prachi dhok)Hi Prachi,
Formula May be like this:
Sum(Sales)*Discount Percenteage/100
So Suppose Your Sales =100,
Discount Percentage= 10%
100*10/100=10
Thanks,
Arvind Patil

Re: How to calculate Discount Value
Sumanta Kumar Mandal Nov 14, 2017 8:11 AM (in response to prachi dhok)Please try with this
SUM(SALES)*SUM(DISCOUNT)

Re: How to calculate Discount Value
Mark Little Nov 14, 2017 9:30 AM (in response to prachi dhok)Hi,
I think your willl the issue is with the discount field, if it shows as 10% it will be dealing with it as a string.
Either in Script add
NUM(PURGECHAR(Discount,'%')) AS DiscountNum
Or in the set analysis
SUM(Sale*NUM(PURGECHAR(Discount,'%')))
Mark

