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

Chandrashekar1997

Misbah

@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

Chandrashekar1997

TQ so much. That works

Krishnarao

Krishnarao