Hi there,
I am creating a finance dashboard for my company. Trying to use the Scorecard charts to show sales and variance and % vs. budget and prior year.
My data is set up in the following structure (sample):
I added scorecards into the dashboard, and wanted to show both the variance in $ and %. However, the “vs Budget” and “vs PY” boxes are not calculating the variance % correctly.
They should be -9.9% and -1.5% respectively. What am I doing wrong? How do I fix it?
Thanks!