fixed functions in etl

abarrie23

Is it possible to add fixed functions in the magic etl? This is the fixed function I'm referring to.

SUM(SUM(Term length (lookup)) FIXED (BY Document Number))

I can add it in as a beast mode, but can't add it as a formula in magic etl.

GrantSmith

FIXED functions only work in beast modes. You can utilize a RANK and WINDOW tile in Magic ETL to do windowing functions.

GrantSmith

FIXED functions only work in beast modes. You can utilize a RANK and WINDOW tile in Magic ETL to do windowing functions.

abarrie23

Very helpful, thanks for the clarification.