Could you please elaborate your query a bit more.
What do you want in the Grand Total?
Thanks and regards,
Thank you for your reply.
I would like to see the Grand Total as 77.5 that is:
Cust # A001: 70 * 0.25 = 17.50
Cust # A003: 80 * 0.75 = 60
=> 17.50 + 60 = 77.50
Is that what you wanted?
workbook (version 9.3) attached for your reference. I've created a separate sheet for grand total.
Some useful links to understand why I took this appraoch
Hope this help. Let me know If you've any query.
Score.twbx 17.0 KB
Thank you very much for your help; that's what I need.
Also thanks for the useful links.
1 of 1 people found this helpful
Kindly close the thread by marking my answer as correct so that this thread gets complete.
Good morning Manfooj,
I logged in to the Forum site.
No, I did not see a "Correct Answer" button; I see only below:
I click on the Action and it shows "No Actions are available."
So, I thought "This Helped Me YES | NO" was what I need to click.
I am using IE 11 but have tried Edge and there is no "Correct Answer" either.
You wont get any option in "Action". If you open your original post in a new tab of your browser then go to the appropriate reply of your post which you seems the correct answer of your question. In that reply just above the action there is a button called "Correct Answer".
Just click on that to close the thread. Else no issue leave it