Calculated fields in 6.3

[prusanoff]

Hello I have followed the instuctions on http://developers.sugarcrm.com/tutor...AgingField.pdf to precalculate certin feilds. i am running V 6.3.1. after following the instuctions to a tee when i do a quik repair the repair modual stops at 'Rebuilding Relationships'. I am a beginner at programing and at sugar so i am gusing this old method will only work for sugar 5. can any one shed some light on this please. Below is my code

In : /custom/Extension/modules/Accounts/Ext/Vardefs

<?php
 // created: 2012-01-20 11:53:18
/* $dictionary['Account']['fields']['gross_revenue_c'] = array (
	'name' => 'gross_revenue_c',
	'vname' => 'LBL_GROSS_REVENUE',
	'type' => 'decimal',
	'function' => array('name'=>'getGrossProfit', 'returns'=>'html', 'include'=>'custom/CustomCode.php'),
	'len' => '18',
	'comment' => 'Automaticly calculated value for gross revenue'
*/
 ?>

In : /custom/Extension/modules/Accounts/Ext/Language

<?php
$mod_strings['LBL_GROSS_REVENUE'] = 'Gross Revenue';
?>

In :

<?php  

class getgross   /* trying to precalculate gross revenue */

 function getGrossProfit($bean, $field, $value, $view){   
    $total_charge_amount_c = ($bean->total_charge_amount_c ); 
    $cost_of_flight_c = ( $bean->cost_of_flight_c ); 
    $miscellaneous_cost_c = ($bean->miscellaneous_cost_c ); 
    $merchant_cost_c = ($bean->merchant_cost_c ); 
    $miles_c = ($bean->miles_c ); 
    $price_per_mile_c = ( $bean->price_per_mile_c); 
	$gross_revenue_c = ( $bean->gross_revenue_c); 
	 
 
$gross_revenue_c = $total_charge_amount_c;
$gross_revenue_c -= ($cost_of_flight_c == null ) ? ($miles * $price_per_mile_c ) : $cost_of_flight_c;
$gross_revenue_c -=  $merchant_cost_c - $miscellaneous_cost_c ;  

if($view == 'EditView' || $view == 'MassUpdate') { //If this is EditView Or MassUpdate Include a field box
$gross_revenue_c = '<input type=text name=Gross Revenue value={$gross_revenue_c} disabled>\n';
}

return $gross_revenue_c;

} 
?>

[jmertic]

You could do this really easily in Sugar Logic by adding a new calculated field with this formula:

 subtract($total_charge_amount_c,if(equal($cost_of_flight_c,null),multiply($miles_c,$price_per_mile_c),$cost_of_flight_c),$merchant_cost_c,$miscellaneous_cost_c) 
  

[rafael.q.g@hotmail.com]

For my experience I say that maybe the issue could be because the file which has the custom function needs to be under include folder. It can't be in any folder as custom/ in your case.

[prusanoff]

You could do this really easily in Sugar Logic by adding a new calculated field with this formula:

 subtract($total_charge_amount_c,if(equal($cost_of_flight_c,null),multiply($miles_c,$price_per_mile_c),$cost_of_flight_c),$merchant_cost_c,$miscellaneous_cost_c) 
  

Hi John

Thank you for the help full hint. the code looks great but were do i put ? Please help!

[jmertic]

Hi John

Thank you for the help full hint. the code looks great but were do i put ? Please help!

This is added to the field in Studio, where you see 'Calculated Field'. This feature is only for PRO and above.

[prusanoff]

Yes i have heard of that in being in pro but i only have the community edition

[vipernet]

Any news?
I'm wondering on how to be able in 6.2CE to sum a list of amounts in a Subtotal printed in a field.
Am i only loosing time due to the CE/PRO limits?
thank you all

vc

[prusanoff]

 subtract($total_charge_amount_c,if(equal($cost_of_flight_c,null),multiply($miles_c,$price_per_mile_c),$cost_of_flight_c),$merchant_cost_c,$miscellaneous_cost_c) 
  

Can i add this to the vardef.php ?????

[andywest]

I made a post about calculated fields last month i think, im sure if you search my posts you will find it. I attached a zip whch might help you