ValueList - Expression Problem

[ljackson]

I'm sure there is a simple solution to my problem, I just can't work out what it is

I have written an expression using a ValueList, which is working fine for the first two parameters on the list.  When I try to add the third value it fails (the column shows nulls throughout).  Can anyone see what I am doing wrong?   I have removed the calculation, and just put in a simple '1' result, just to try and get the value to show on the table - at the moment I can only see the first two values (Ambient and Multi Temp)

Can anyone help?

Thank you

[ljackson]

Seems strange as you said the individual expressions work in a text box .......not sure my last amend will make any difference

I found a similar thread, looks like it's something to do with the aggregation:

Multiple Aggr() in Pick/Match function