The OneStream Community is temporarily frozen until June 29th due to the ongoing maintenance. Please read the blog post here to learn more.

Forum Discussion

HHoensheid's avatar
HHoensheid
Icon for OneStream Employee rankOneStream Employee
2 years ago

If Statements in Books

I have a requirement for a book to produce different views (i.e. Periodic, QTD, YTD) based on the WFTime. The periodic report should always appear no matter the WFTime, however the QTD Version will o...
Books
Reports
Noemi's avatar
Noemi
Icon for OneStream Employee rankOneStream Employee
2 years ago

Hi, could you try to use this if statement (it worked for me)

(|WFTime| Contains M2) or (|WFTime| Contains M3) or (|WFTime| Contains M5) or (|WFTime| Contains M6) or (|WFTime| Contains M8) or (|WFTime| Contains M9) or (|WFTime| Contains M11) or (|WFTime| Contains M12)

I was also not using a loop definition for my dashboard parameter (as I could define it directly in the change parameter item, as you did).

Please let me know if that works for you.