IF(Company='HMG' and [Creation Year]=2018 , 0.59,0)
However what I would like to do is creating two references lines when users select Company and Creation Year. I realized that I can create multiple Reference Lines by just adding a new reference line "Add reference Line".
IF(Company='HMG' and [Creation Year]=2018 , 0.68,0)
In my case it is not a solution because when the user select another company , I will have the another reference lines as well.
What I need is to add two reference lines depending on the Company and Creation Year.
if(company = 'a' and year = 2018, x, if(company = 'b' and year = 2018, y, z))
and you might also include a further check if the companies are external/internal, with getselectedcount() the number of selected values and many more, whereby by a larger number of conditions it might be easier to add these data within the datamodel instead of using very deep if-constructs.