Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Field expression formulas
#1
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
Reply
#2
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.
Joe
TSolucio
Reply
#3
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
Reply
#4
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
Reply
#5
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
Joe
TSolucio
Reply
#6
The formulas and update fields really do work well and your desired formula is really simple. I doubt the problem is there.
Joe
TSolucio
Reply
#7
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
Reply
#8
Is there a way inside Corebos to have the Digit Grouping Pattern 123,456,789 and the workflow equations still work properly?
Reply
#9
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.
Joe
TSolucio
Reply
#10
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 -->
Reply


Forum Jump:


Users browsing this thread: 1 Guest(s)