Quarter Boolean to check off at the last month of the quarter
Hello,
I currently have a Boolean that is manually checked. It is selected at the quarter level. How could I get it to check off another boolean that is monthly? I would like it to check off at the last month of the quarter. Please let me know if this is clear.
Thanks
Best Answer
-
you can create one line item at monthly level and add this logic.
Parent(item(time))<>next(parent(item(time))) and quartervalue(quarter check line item)
Thanks,
Manjunath1
Answers
-
Is there one line for the quarterly input and another line for the monthly?
If so, I'd use QUARTERVALUE()
You could do a LOOKUP[X] using another line, but QUARTERVALUE() is significantly more efficient.
0 -
so this works but it selects all the months in the quarter not just the last one. I need just the last month of quarter
0 -
this worked , thank you so much
0