Boolean to time period

Nalin
edited July 2023 in Modeling

Hi I have a boolean line item checking months from jan-dec 2023 and I have another module which is time period formatted(months).I want a formula that applies to the first module through 2nd module that when a user select months from module 2 then the boolean is checked automatically in module 1.

Best Answers

  • jagadishdash
    Answer ✓

    OR If the requirement is reverse way:

    Module 2

    Module 1

    Hope it helps. Let me know if the scenario is anything else.

    Thanks,

    Jagadish

  • jagadishdash
    edited July 2023 Answer ✓

    @Nalin Great! As it solved the issue for you, Can you accept my answer as a solution so anyone else having the same issue will get help too!

    Thanks,

    Jagadish

Answers

  • Hi Nalin,

    When you say you are selecting month in module 2, how are you doing it?

    Can you please give more insight on what you are doing in module 2?

    Thank you,

    Harshitha

  • Lets say you are selecting the month in 'Module 2'.'Select Period' [Time Period (Month) Formatted line Item]

    [Assumption: The Module 1 where you need the logic contains a time range (Anaplan-inbuilt Calendar/Time Ranges)]

    'Module 2'.'Month Selected?' ⇒ Use Formula: ITEM(Time) = 'Module 2'.'Select Period'

    Let me know if this solve your issue

  • Hi @Nalin As per my understanding of requirements, attached below : If it's not the requirement can you elaborate it mlore clearly.

    Module 1

    Module 2

    Thanks,

    Jagadish

  • Thanks this works perfectly

  • Hi @jagadishdash I need to have this month selected (April 22) to be populated for all the months rather than only for April. How can we do it?

  • @MayurTiwari5780 What's your requirement? can you explain please? the above answer for the earlier requirement.