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'[BY SUM: -> EE_Data_Stand.Area][by: 'GL Account'."11100"][remove sum: Employee][by :-> MAP_Datatype]
Thanks
