Skip to main content

Hi,

I want to add some data to the dashboard only when the year value increases beyond 2011. I have created a calculated field to show that data.

However, the percentage value changes when trying to only show beyond a particular year using the formula below. I cannot understand why this is happening and how I can fix this. I am open to use other ways to achieve the desired goal.

 

Formula used:

IF [Year] > 2011

THEN

[PercentageOfHeroin]

END

 

PercentageOfHeroin:

{ FIXED [Drug],[Year]:SUM(If [Drug]="Heroin" THEN [Deaths (DeathsDrugType)] END)}

/{FIXED [Year]:SUM([Deaths (DeathsDrugType)])}

 

Attaching the workbook for reference. The concerned sheet is "Question"

Thanks In advance for your time and help.

1 respuesta
0/9000