please see the attached
you could use the first formula below to give you the individual totals and grand total to properly sum them or the second formula to give you the proper fixed overall total
then return this
If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution. Thank you.
Example (3)_v10.2.twbx 22.3 KB