Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 years ago
Solved

FILTER vs CALCULATETABLE

I'm about to lose some serious street cred, but so be it... :)   I use FILTER( ) all the time and CALCULATETABLE( ) almost never.  Is there some time I *should* be using CALCULATETABLE?  What is th...
Need Help
Tutorial Requests
  • mattbrice's avatar
    mattbrice
    9 years ago
    Anonymous wrote:

    What if I remove CALCULATETABLE from the language.  What do we lose?

    CALCULATETABLE triggers context transition whereas FILTER does not.  Andy by itself, FILTER creates a row context whereas CALCULATETABLE does not.  But other than these, it is a question for Marco if he is lurking around out there...potential performance issues per his article I referenced would be one thing I would think...

Anonymous's avatar
Anonymous
Not applicable
9 years ago

What if I remove CALCULATETABLE from the language.  What do we lose?

mattbrice's avatar
mattbrice
Icon for Solution Sage rankSolution Sage
9 years ago
Anonymous wrote:

What if I remove CALCULATETABLE from the language.  What do we lose?

CALCULATETABLE triggers context transition whereas FILTER does not.  Andy by itself, FILTER creates a row context whereas CALCULATETABLE does not.  But other than these, it is a question for Marco if he is lurking around out there...potential performance issues per his article I referenced would be one thing I would think...