Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear all,
I have a margin formula with set analysis. this is the syntax:
How can I make this cleaner?
It is neccesairy because the set analysis identifier (1) does not work. when I select other weeks than "currentweek" it shifts to zero.
Thank you in advance,
simon
is the peildatum a value in the currentweek? if your data is not deriving these to date fields, peildatum and currentweek from a master calendar then I would expect that these 2 cancel each other and result in the 0 value.
What is your question in making this cleaner? Which part do you want to clean?
no peildatum and currentweek are two different values.
my end goal is to make it ignore filters. now when i set the year filter on 2021 it shifts to zero, but with the set analysis identifier 1 it should ignore filters