Field expression formulas

[myhomewise]

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

[joebordes]

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.

[myhomewise]

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

[myhomewise]

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

[joebordes]

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

[joebordes]

The formulas and update fields really do work well and your desired formula is really simple. I doubt the problem is there.

[myhomewise]

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

[myhomewise]

Is there a way inside Corebos to have the Digit Grouping Pattern 123,456,789 and the workflow equations still work properly?

[joebordes]

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.

[myhomewise]

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 -->