I opened this file for the first time. There is a sales column and a discount column both. For total net sales do we take sales as it is, or minus the discount first? Not sure which one is correct. How did you do it?
AD
admin_findi360
Good question to ask first. You don’t need to subtract anything: the fact table already carries NetSalesSAR, which is sales after discount. Sum that column over the whole period. If you want to prove it to yourself, take one row and check gross minus discount equals net. Post your total and I’ll confirm it.
A free account takes a minute. Your draft is kept while you sign in. Need help? Message us