Sum/count issue

[sat_tok52]

Hi guru's,

I am  comparing current year vs last year against region using bar chart ,when I select filter 2015 it working fine with percentage format in y-axis ,when i select filter 2016 it is not working ,the y-axis still apperas number format .Both expression i have checked percentage check box in number tab.When I remove denominator it's working both filter. Any help.

I am using below expression.

Sum( {<Date={">=$(vPriorYearStartDate) <=$(vPriorYearEndDate)"}>} Amount)

/

(Count( {<Date={">=$(vPriorYearStartDate) <=$(vPriorYearEndDate)"}>} [Account Name])

Sum( {<Date={">=$(vCurrentYearStartDate) <=$(vCurrentYearToday)"}>} Amount)

/

Count( {<Date={">=$(vCurrentStartDate) <=$(vCurrentYearToday)"}>} [Account Name])

--Sateesh

[Anonymous]

Maybe you need to use the Set Analysis 1 for all records - as in ignore selections :

Sum( {1<Date={">=$(vPriorYearStartDate) <=$(vPriorYearEndDate)"}>} Amount)

/

(Count( {1<Date={">=$(vPriorYearStartDate) <=$(vPriorYearEndDate)"}>} [Account Name])

Sum( {1<Date={">=$(vCurrentYearStartDate) <=$(vCurrentYearToday)"}>} Amount)

/

Count( {1<Date={">=$(vCurrentStartDate) <=$(vCurrentYearToday)"}>} [Account Name])