Chart expression to lookup reference table?

[robinrouleur]

Hi

I am trying to calculate a total price within a chart table when the unit price depends on two aggregated values(volume & service level).  The unit price is the same across all units so I just need a way of using the aggregated values to look up a reference table but there doesn't seem to be a chart function to do this?  "Lookup()" would be ideal but it is only available as a script function.

Can anyone suggest a suitable chart function or an alternative approach?

Robin

[danieloberbilli]

Maybe the  only() function works (...if [ExpressionTotal] = only(LookUpField)  )  , if there is one (lookup) value only else it returns false