# percent change is showing a large #

Member

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

• Coach

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.

** Did this solve your problem? Accept it as a solution! **

• Coach

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.