Which aggregate function is good at performance


Hi, I want to use aggregate function.

I want to aggregate "Date" Lineitem from Order A&B to Aggregation Module.

Date Lineitem has Date format.


I use " OrderA.Date[Max:Product]" as Formula.

And I can also use "Fristnonblank" and so on because Date Lineitem is common in module.


Which Formula is good at performance?







Each Order has Product, But Product will not duplicate.

And Order A and Order B has own date. It depends on Own module.

Best Answer

  • Misbah
    Answer ✓



    I don't think there is any work that has been done on the comparison of the performance of these aggregation functions. I have a feeling that these two will perform almost similarly.



    Miz Logix