Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Folks,
i have a question: is that possible to create a dynamic bookmark with 2 values:
For instance: my data do look like:
MyYear, Turonver
2022 , 100
2021, 50
2022, 25
i created a dynamic value with only 1 value and it does work: =MyYear = Year(Today())
i tried to expanded this expression and created this expression: =MyYear = Year(Today()) and Year(Today())-1 but it does not work.
Has anyone experienced similar case and does anyone have an idea how to create a dynamic bookmark with 2 values. I only want to show the current and previous year when i activate my bookmark.
Thanks a lot
Bek
Hi, have you tried >= without 'and' condition?:
=MyYear >= Year(Today())-1
If this not work, maybe set analysis could help here, something like this:
{<MyYear={"=MyYear>=year(today())-1"}>}
Hi, have you tried >= without 'and' condition?:
=MyYear >= Year(Today())-1
If this not work, maybe set analysis could help here, something like this:
{<MyYear={"=MyYear>=year(today())-1"}>}
Hi @justISO thank you very much, it does work,
thanks a lot for your time and your help