Which of these two options has the best performance?

Guilhermecord10
Guilhermecord10
in Modeling

Hi Guys!

I have a module that consolidates values ​​in a list called Supplier L5 (this list has 5 levels), let's call it CONSOL01.

The modules that feed CONSOL01 are not dimensioned by Supplier L5, so when consolidating I need to assign a dimension.

I'm currently doing it this way:

Value[SUM: SYS01 - LookUp Module.Supplier L5]

But I also thought about doing it this way:

If
Item(Supplier L5) = SYS01 - LookUp Module.Supplier L5 then
Value
Else
0

The problem is that there are 5 value line items in CONSOL01, so my formula would have several IF's/Else's

What is more performant in this case?

Creating line items inside the value modules is not an option because each line item costs me 60M cells :(

Best Answer

  • seymatas1
    seymatas1
    Answer ✓

    Hi @Guilhermecord10,

    If possible, avoid nested if statements. So, the first solution should perform better than the second one.

    Seyma 🌷🙂

Answers

Categories