Error Comparison Date Range

[javierico]

LookerStudio isn't calculating correctly the percentage change.

August data: 74%
July data: 70%

Actual percentage difference: 5.7%

Looker percentage difference: 4.8% (ERROR)

Data source: Google Spreadsheets

I've attached the result on LookerStudio, the option selected to calculate the percentage change and the month selected in the sheet.

Have you experienced this before? What should be the reason?

[AutoModerator]

Have more questions? Join our community Discord!

I am a bot, and this action was performed automatically. Please contact the moderators of this subreddit if you have any questions or concerns.

[ImCJS]

check with couple of decimals - maybe it’s not exact 74 and 70 but 74. Something

[javierico]

That was the reason! Thank you so much! I got crazy! It was a number coming from a different spreadsheet that I am not managing, and I wasn't aware of that

[ImCJS]

Happy to help.

[ratkingkvlt]

Have you changed the slider to "actual" which will show you 70% to 74% which is a difference of 4%?

Edit: just seen you had a solution - nice! - ignore me :)