Hi, Can you please post your workbook or a mock data so we can see where you are getting it wrong otherwise there are too many variables that may cause this problem. Please post it as .twbx file. Thank you
Yes, please attach a workbook for the most accurate solution. But if I were to guess, you simply need to adjust the "Compute using" option in your table calculation.
I agree with Ryan,
It could be due to the Computing using or Edit Table Calculation settings. See below pics and try to play with them and see if you can get your desired result.
If not, we should look at your workbook or mock file of your data. Thank you and please let us know.
Also, I would really encourage you to read Table Calculations: Addressing and Partitioning as it will help you a lot with your future calculations.