Multiple SUM&LOOKUP splitting workaround
I am trying to split multiple SUM&LOOKUP's used in a lineitem in a module in order to optimize the model performance. But while splitting the SUM & LOOKUP into different line items in separate modules (dimensioned by lists used in SUM&LOOKUP) , the result is not coming as expected. Since the size of lists is quite huge, i cannot even combine the lists being used in the SUM&LOOKUP as part of one module and then aggregate the value to final module. I know its not best practice to use multiple SUM&LOOKUP together, but the requirement is such that we have to sum the transaction value based on multiple attributes . Is there any workaround for the same where more than 3 SUM&LOOKUP are being used in a single line item
Thanks in advance!