percent change is showing a large #

kodonnellLT
kodonnellLT Member
in Charting

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)

image.png

(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)

Best Answer

  • ArborRose
    ArborRose Coach
    Answer ✓

    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.

    image.png

    ** Was this post helpful? Click Agree or Like below. **
    ** Did this solve your problem? Accept it as a solution! **

Answers

  • ArborRose
    ArborRose Coach
    Answer ✓

    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.

    image.png

    ** Was this post helpful? Click Agree or Like below. **
    ** Did this solve your problem? Accept it as a solution! **

  • ArborRose
    ArborRose Coach

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

    (2.2 - 2.88) / 2.88

    image.png

    ** Was this post helpful? Click Agree or Like below. **
    ** Did this solve your problem? Accept it as a solution! **

Categories