Skip to main content

Hello,

As I start my pigment training and work through the formula exercises, I have a question regarding the order of using multiple modifiers within a single formula.

I’ve read that the sequence is important when combining BY and FILTER. In the same way, are there any best practices or modeling guidelines that affect performance or functionality when using several modifiers and operators together in random sequence, such as BY, BY->, Select, Filter, Add, Remove, or Exclude?

Below is one example from the formula exercises (it may be a simple formula but I am thinking about what sequence to follow for complex formulae):

'EE_Calc_MonthlySalary_+increase'sBY SUM: -> EE_Data_Stand.Area]eby: 'GL Account'."11100"]0remove sum: Employee]eby :-> MAP_Datatype]

 

Thanks

Hi ​@sudhakar,

I would advice you to read this, particularly part 11

Hopefully, you will find there the answers to your question

 

Regards,

Yuri


These modeling tips are very helpful. Thanks ​@Yuri Pinchuk

Thanks,

Sudhakar


Reply