Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
HI,
I'll try to use dynamic filter for the dimesion where the format is Yearmonthnumber like 20212.
I have selected dimension VuosiPeriodi
Value is: =(Year(addmonths(Now(),-1))&num(month(addmonths(Now(),-1)))),
but this lead to error. If I put directly 20211 it works fine.
How I should create a dynamic filter that it is working.
Thanks!
Regards, Jarmo
Hi,
Be sure that both, the field and the formula result, are of the same type. For example you could force the formula to return a string by adding a Text().
Remember also to select Evaluate value from the dropdown menu.
Best Regards,
Ruggero