My Sum calculation is doubling values without it asking me to

[ahfadoo]

Here is an example:

I am trying to have a Sum column for the years shown in the image but when I input values the Sum is doubling the values. I know it has something to do with my measure but I am not sure how to fix it.

Thanks!

[N1kh1l]

ahfadoo

You will need to provide what's the measure you are summing and whats the configuration of the measure like aggregation etc.

[N1kh1l · Accepted solution]

ahfadoo

If its a client calculation just check the formula being generated in formula bar. It will give some insights. May be a column is being summed twice.

Br.

Nikhil

[N1kh1l]

ahfadoo

Glad it worked for you. Could you mark the correct answer, currently you marked your reply as the correct one.

Br

Nikhil

[ahfadoo]

nikhil_1486

Does this help?

I also want to add that I attempted to change the exception aggregation type to "None" but that resulted in me getting a slash in my data cells making them inaccessible.

Thanks! Ammar

[N1kh1l]

Measure looks fine. What is Sum ? Table level client calculation ? Story calculated measure ? Also you should rows of the table being summed.

[ahfadoo]

nikhil_1486

It's a table level client calculation

[ahfadoo]

nikhil_1486

Thank you so much! I saw the formula and I rewrote it which made it work correctly. This is an interesting feature I hadn't seen before. Thank you for the help!

Regards, Ammar