Incorrect Value returned when doing YOY change

[bishtasu]

I have created calculated field called current year and same period previous year using the below formulas

Current year - min(ifelse({Creation Date modified}>=${StartDateYTD} and {Creation Date modified}<=${EndDateYTD}, amount,0),[id])

same period previous year - min(

ifelse(

extract(“YYYY”, {Creation Date modified}) = extract(“YYYY”, addDateTime(-1,‘YYYY’,${StartDateYTD}))

and {Creation Date modified} >= addDateTime(-1,‘YYYY’,${StartDateYTD}) AND

{Creation Date modified} <= addDateTime(-1,‘YYYY’,${EndDateYTD}), amount, NULL

),

[id])

But when I’m doing sum(current year) - sum(same period previous year) I’m getting incorrect result.

Current year gives me - 59.9
same period previous year gives me - 113.7
but the difference I’m getting is -85.4

[apjvinod]

Hi @bishtasu

Welcome to QuickSight Community .

Could you please upload the sample data and create the analysis in Arena and share it here , this will help us to understand and help you better .

QuickSight Arena -- An embedded instance of QuickSight within the QuickSight Community

[FeatureTile 11(2)] Watch this video for a 30 second intro to Arena. QuickSight Arena provides you with an embedded instance of QuickSight right within the QuickSight Community. Using Arena, you can: Explore creating QuickSight data visualization dashboards for free Publish dashboards to the Community Gallery to showcase your skills Include dashboards depicting your use case while posting questions in the Community Q&A Clone underlying analysis views of published dashboards in order …

Thanks
Vinod

[Brett]

Hi @bishtasu,
It’s been awhile since we last heard from you, are you still facing issues regarding your initial topic or were you able to find a solution?
If still in need of assistance, please follow the prompt above to create an Arena view of your analysis so that we can assist further.

If we do not hear back within the next 3 business days, I’ll go ahead and archive this topic.

Thank you!

[Brett]

Hi @bishtasu,
Since we have not heard back, I’ll go ahead and archive this topic. However, if you have additional questions, feel free to create a new topic in the community and link this discussion for relevant information.

Thank you!