AnsweredAssumed Answered

Circular Reference formula on sugarcrm 7

Question asked by Joe Davies on Nov 20, 2016
Latest reply on Nov 23, 2016 by Joe Davies

Hi All,

 

So i've been creating formulas based on an excel file, now i'm having issues replicating this on studio.

So the formula somewhat goes like this :

 

Field 1
= Field 2 * 1.1 * 1.25 * 0.5 

 

Field 2
= value1 + value2 + value3 + Field 1

 

so as you can see, field 1 uses the value of field 2 but since field 2 also uses field 1.

 

This causes unexpected behavior:

1.) The fields would show values when saving the record

2.) Since on Field 2, field 1 is still missing, it wouldn't display any value even if i already input values1, 2 and 3.

 

I can't seem to get this done using the formula available in studio, Hope you guys can help me on this.

Thanks

Outcomes