Hi All,
I have a question about daisy chaining versus not repeating a formula. From what I understand, the engine will calculate the below module faster if I didn't reference Division and Deal Size in the Selected line item.
Line item | Selected | Division | Deal Size |
Formula | (ISBLANK(Division) OR FilterSelections.Division = Division) AND (ISBLANK('Deal Size') OR FilterSelections.'Deal Size' > 'Deal Size') | DAT01.Division | DAT01.'Deal Size' |
This makes sense because the engine will have to calculate Division and Deal Size before calculating Selected.
I think in this example it is reasonable to reference the data module directly in the Selected line item.
However, let's say we have a similar example but the Division and Deal Size line items require an IF THEN statement and multiple SUMS. In this case it seems the Planual provides conflicting guidance. Do I avoid duplicating my formula or do I worry about daisy chaining?
Additionally, where does auditability fit in? The Selected line item is going to get very complicated if I try to avoid daisy chaining.
Thanks,
Chris