expression is null

[Anonymous]

Is there a way to do a same expression like this in pivot table

Case when price1 is null then price 2

[MK_QSL]

SUM(If(isNull(price1),price2,price1))

[swuehl]

In general. you should use aggregation functions, try maybe something like

=Sum( If( len(trim(price1)), price1, price2))