Total column to count correctly

Hi how can I get my total column of a calculated field to count correctly?
this is the formula for the calculated field:
image
in the total column it does not add up all of the values
thanks!

HI @kiahhobs
could you share a sample to verify?
BR

hey, the ‘visits’ column is not counting correctly

In case you need further assistance with your problem, please create a sample dashboard with sample dataset showing your problem state using Arena and please create a new post, so we can look at it from a fresh perspective. (Details on using Arena can be found here - QuickSight Arena)

Hi @Michelle, try using the built in totals and subtotals. Also, try using the Amazon Q Assistant on the documentation page.

Did this solution work for you? I am marking this reply as, “Solution,” but let us know if this is not resolved. Thanks for posting your questions on the QuickSight Community!