Quarter Boolean to check off at the last month of the quarter

Options
Olek P
Olek P
edited January 2023 in Modeling

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

Tagged:

Best Answer

  • ManjunathKN
    ManjunathKN
    edited November 2022 Answer ✓
    Options

    @opolishchuk 

     

    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,
    Manjunath

Answers

  • luke_e
    luke_e
    edited November 2022
    Options

    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.

  • Olek P
    Olek P
    edited November 2022
    Options

    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

  • Olek P
    Olek P
    edited November 2022
    Options

    this worked , thank you so much

Categories