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

edited June 1 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,


    Miz Logix

  • TQ so much. That works