I am trying to create a guage that uses the following formula: #CALC_SUM.deal2( back | false ) back is a formula field. it is not letting me validate this formual. Can you not use a formula field for a guage? if you can what am i doing wrong?
Unfortunately you can only use fields with actual data in CALC_SUM expressions. In simple case you can just replicate your formula in CALC_SUM body using SQL-style synrax (please consult Chapter 6).
Otherwise you can use LOOP construction, although that will not be an effective solution (not recommended).