Amount mismatch issue seen between Quicksight and Snowflake though similar logic used in both. The reason behind this problem might be the time zone . Please give the appropriate solution for this issue. Please find the attached snapshot for more detail
We don’t have access to your data.
I would suggest trying out the timezone difference. You can do this by addDatetime in a calculated field or changing your date in sql to take into the timezone affect.
Here is documentation if you want to add / subtract hours to your date field in quicksight.
@rajesh - Can you also check the timezone where your Snowflake and QuickSight hosted, both the systems are SaaS( Software as a Service).
Regards - Sanjeeb