Facing a issue in representing KPI in trend chart

[manu1512]

Hi Friends ,

I am facing very weird issue .I am using following KPI in line chart

=Sum({<Equipment_isSMA_Upgrade_Eligible={1},Temp_isEquipmentNoContract={0},Is_Deleted={'N'},Flag ={1},Mod_EquipmentStartDate={"<=$(=(Max(DateID)))"},Valid_From_Date={"<=$(=(Max(DateID)))"}>}   EquipmentCount) +

sum({<Equipment_isSMA_Upgrade_Eligible={1},Temp_isEquipmentNoContract={0},Is_Deleted={'Y'}

,Flag ={1},Mod_EquipmentStartDate={"<=$(=(Max(DateID)))"},Valid_From_Date={">$(=(Max(DateID)))"}>}   EquipmentCount)

Whenever i am putting following KPI in line chart ,

I am getting a different value for particular year if i made of  selection of  that year ,but without selection we are getting different value.

In snapshot 2015 showing us the value individually as 6.42 while without selction it is giving us value of 7%

PFA the snapshot  and application and pls help me

[Anil_Babu_Samineni · Accepted solution]

Can you please share application

[manu1512]

I have attached

[manu1512]

issue is solved

[Anil_Babu_Samineni]

Okay, You can make your response as correct answer and putting the correct scenario.