John,

You suggestion worked and eliminated the error! Thank you for your help!

Why not just do the same calculation, but for everything in group 1, as you did in the computed field for group 2, rather than trying to have a sum of the computed field from the group 2 values?

So for instance if the computed field in group 2 was "sum(amount for group 2)" the computed field in group 1 will be "sum(amount for group 1)".

I'm not at all sure that compute expressions in a lower-numbered group can refer to names of computed fields in higher-numbered groups. (I certainly can't recall having ever either tried or needed to do that.)

computed field #2 - if(  bid_ranking =1,   c_bid_amount_total  , 0 )

c_bid_amount_total is computed field #1

This is what is in the DW source. I did not see what you stated:

expression="if(  bid_ranking =1,   c_bid_amount_total  , 0 )"

Hi, Raymond -

What is the value of computed field #2 when the If condition being tested is false? Can you supply the expression for computed field #2?

If you edit the DW source and look at the line that defines computed field #2, what is the value of the "expression" property (it's near the start of the line). The reason I'm asking for this is I'd like to see the default value for the computed field (it precedes the tab character that separates the default value and actual expression you see in the expression builder dialog window).

I suspect this default value, if present, is NOT a number.

Best regards, John