Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I want to Show in my Chart the value 0.8 for every year >2019 and if Year<=2018 the value 0.77 should be shown. Why does it only work when i don't select any month. I used following Formula: IF(Year<2019,0.77,0.8).
If I select a month for the Year 2018 see appendix what happends
I am not clear on the issue. could you share a screenshot how it looks before month selection and after month selection.
Also which is the relevant expression is it the line or the bar?
If I don't sselect a month, the right value for 2018 (0.77) is shown for every month. If I select a month, the right value is only shown for the selected month. Thanks for helping.