HiI want to use quarterly sum in another module which is in months. How to do that?

Chandrashekar1997
edited June 2023 in Modeling

Best Answers

  • Misbah
    Answer ✓

    @Chandrashekar1997 One of the possible ways to achieve this is by creating three lines in SYS Time module and writing the formula accordingly in CALC module. See below

    DAT Module

    SYS Time Module - Here I have manually selected the month in which the bonus needs to be paid. You can automate this boolean also.

    Quarter → Parent(Item(Time))

    Previous Quarter → Quarter - 1

    Bonus Month → Manual

    CALC Module

    Hope that helps,

    Misbah

    Miz Logix

  • TQ so much. That works

Answers