
hello,
I want to add the total discount % on my sales invoice report, but im facing some issues.
to add the discount percentage which are 3.00/7.00/5.00 , im using the following expression: =iif(Fields!ShowGoodsDiscount1.Value = "No", Fields!DiscPercent.Value, Labels!@SYS95973)
but im having issues on adding the total discount % which is 10% and should show for all the items.( i guess the field name of the total discount % is also DiscPercent)
my other issue is regarding the taxAmount field. the calculation should be: Quantity-Discount Percentage-Total Discount Percentage
any help how it can be done?
thanks