So, this is a strange one. Attached here is the excel sheet that is downloaded from the data that you can see in the screenshot below. Somehow, the summation of List price and revenue is both showing 0 (as it should) in excel, but showing some data in Tableau.
This is completely wrecking the Discount% calculation.
Discount% = (SUM(List Price)-SUM(Revenue)(/SUM(List Price)
1 answer
Hello @Pratiksha Haldar ,
Can you upload your Tableau workbook? And let me know which download is not working correctly?
@Robert Breen
