percent change is showing a large #

kodonnellLT

I created this beast mode which has the logic (current value- previous value)/(previous value). however when I show it in the summary and change the format to percentage it gives me a large percentage number. I'm trying to calculate the difference between 2.88(prev) and 2.2(current)

(avg(CASE WHEN created date >= '2023-07-01' AND created date <= '2023-12-31'

THEN 

(CASE WHEN DATEDIFF(first present date, created date) <0 THEN 0
WHEN DATEDIFF(first present date, created date) <=90 THEN DATEDIFF(first present date, created date) END)

END)   

avg(CASE WHEN created date >= '2023-01-01' AND created date <= '2023-06-30'

THEN 

(CASE WHEN DATEDIFF(first present date, created date) <0 THEN 0
WHEN DATEDIFF(first present date, created date) <=90 THEN DATEDIFF(first present date, created date) END)

END))

/

avg(CASE WHEN created date >= '2023-01-01' AND created date <= '2023-06-30'

THEN 

(CASE WHEN DATEDIFF(first present date, created date) <0 THEN 0
WHEN DATEDIFF(first present date, created date) <=90 THEN DATEDIFF(first present date, created date) END)

END)

ArborRose

It looks like you are trying to do YTD comparisons. I would try it something like this….

Create a formula for SUM, AVG, COUNT for Current Year (CY) and same for Previous Year (PY). Then you can throw them up on to a card to see side by side comparisons.

ArborRose

It looks like you are trying to do YTD comparisons. I would try it something like this….

Create a formula for SUM, AVG, COUNT for Current Year (CY) and same for Previous Year (PY). Then you can throw them up on to a card to see side by side comparisons.

ArborRose

Your value should look like a decimal before you format as percentage.

(2.2 - 2.88) / 2.88