I appear to have an issue with my field expression formulas:
<!-- m --><a class="postlink" href="http://awesomescreenshot.com/09c4e2tfc5">http://awesomescreenshot.com/09c4e2tfc5</a><!-- m -->
the formula should be as follows Totals Fees = promo fees + merchant fees + lender fees
here is a screenshot
<!-- m --><a class="postlink" href="http://awesomescreenshot.com/0ed4e2tn28">http://awesomescreenshot.com/0ed4e2tn28</a><!-- m -->
it edit view the forumla works:
<!-- m --><a class="postlink" href="http://awesomescreenshot.com/0214e2tufd">http://awesomescreenshot.com/0214e2tufd</a><!-- m -->
I have not made no changes to code only created custom fields
Try putting the sum directly, eliminate the equal sign
Code:
cf_696 + cf_698 + cf_700
note that this is execute on the save event, not when loading the edit screen
Also, please use the workflow update field task, Field formulas are obsolete, workflows are more powerful and will keep getting bug fixes and enhancements while field formulas will be left there as it is only for backword compatibility.
I did both things you requested I eliminated the "=" as well as created a workflow vs a field expression. I am still experiencing a similar problem. I am now also having if I enter 1,000 in 1 custom field and 500 in another the values will change and the total fees formula does something odd.
FYI these are all currency fields with 7 value length and 2 decimals
what it also seems to do for example if i add 10,000 to a currency field it will drop zeroes it change it to 10
Try eliminating the formatting from the users configuration. That part of the code never quite worked correctly. Set it to work as:
- no grouping nor thousand separator
- point as decimal
The formulas and update fields really do work well and your desired formula is really simple. I doubt the problem is there.
After changing :
Digit Grouping Pattern 123456789
the problem was eliminated
How come this problem never occurred in the original Vtiger 5.4, I ask because i preferred, Digit Grouping Pattern 123,456,789
Is there a way inside Corebos to have the Digit Grouping Pattern 123,456,789 and the workflow equations still work properly?
I'd say this has happened always, that part of the code has never worked correctly since it was released by vtiger. In other words, vtiger crm 5.4 had the same problem and we haven't looked into fixing it (yet).
I have been telling users of vtiger CRM 5.4 the same thing I told you for years.
At the moment there is no solution. We will look into it eventually but there are more important things in front.
I have provided some screenshots showing this works in Vtiger 5.4
<!-- m --><a class="postlink" href="http://awesomescreenshot.com/0f74eadn20">http://awesomescreenshot.com/0f74eadn20</a><!-- m -->
<!-- m --><a class="postlink" href="http://awesomescreenshot.com/0dd4eaer19">http://awesomescreenshot.com/0dd4eaer19</a><!-- m -->
<!-- m --><a class="postlink" href="http://awesomescreenshot.com/0284eaf660">http://awesomescreenshot.com/0284eaf660</a><!-- m -->