Nested IF Statement in Pivot Table

[#1]

Can I use Nested IF statements in pivots table to show different data depending on what value a particular field show.

I have a standard if statement working, but have three possible values hence the requirement for nested which I can't seem to get to work.

Working IF Statement

if(component_make_or_buy='M',rangesum(wo_quantity_remaining),rangesum(sum(po_qty_ordered)-sum(po_qty_received)))

Non working Nested IF Statement

if(component_make_or_buy='M',rangesum(wo_quantity_remaining),if(component_make_or_buy='B',rangesum(sum(po_qty_ordered)-sum(po_qty_received)))

I know there are only two elements above but I planned to add the third once this was working.

[Anonymous · Accepted solution]

Your second expression with the nested IF() is missing a closing parenthesis. You will also want to be careful to insure that the field you are testing (component_make_or_buy) can only have a single value at any time or the expression will return null.

[Anonymous]

Hi.

Technically, there is no problem to use nested if's in Pivotable, we've done it.

However, it will be a lot more performant to do those calculations in your loading script (btw, it will be more readeable to the user too, when creating new objects).

Best regards,

Miguel Catalao

[#4]

Thanks, it was just that missing bracket.