=if(not(isnull(only({[s_Hier_Comp2]} fieldA))),
aggr(only({<ASSET_CLASS=P({s_Hier_Comp1}) * P({s_Hier_Comp2})>} ASSET_CLASS), ASSET_CLASS),
aggr(only({<ASSET_CLASS=P({s_Hier_Comp3}) * P({s_Hier_Comp4})>} ASSET_CLASS), ASSET_CLASS)
)
I have the above statement in an expression for a list box.
I need to apply a union of 2 alternate(s) based on my if condition (if there is a value for fieldA.
There seems to be some syntax issues in this, need to re-structure my aggr/if
Gerry
