Good Day All,
I am trying to add a rollup field to a parent object (Invoices) to sum up the total of each line item on the child object (invoice line items). Can't seem to roll up this "total" calculated field on the child object to a grand total on the parent object. Tried roll up summary field, but that calculated child field wasn't an option... Do I have to do a formula field with javascript?
Thanks
Jeff
Yes. you are right. You have to do a formula field with JavaScript.
An example as below:
Create a formula field (Decimal) say "Invoice". and the code snippet to be used there is:
var totalInvoice = 0;
{!#LOOP_BEGIN.R241825084}
totalInvoice += {!Percentage};
{!#LOOP_END.R241825084}
return totalInvoice;
In this example script, R241825084 is the "relationship Name" of the child and {1Percentage} is the field in child object which I want the sum to be rolled up.
Hope this helps!
Yes. you are right. You have to do a formula field with JavaScript.
An example as below:
Create a formula field (Decimal) say "Invoice". and the code snippet to be used there is:
var totalInvoice = 0;
{!#LOOP_BEGIN.R241825084}
totalInvoice += {!Percentage};
{!#LOOP_END.R241825084}
return totalInvoice;
In this example script, R241825084 is the "relationship Name" of the child and {1Percentage} is the field in child object which I want the sum to be rolled up.
Hope this helps!
Hi intekra,
To enable the roll up field, you need first to establish a relationship between the objects..
After creating the relationship the field Roll up shows up in the list of available field type.
When selecting roll up field, the next option is to select witch relationship, field and computation will be used to calculate this field.
When selecting SUM, Rollbase creates a formula field with following code:
#CALC_SUM.R9367(Amount)
Where R9367 is the relationship name and Amount is the field in the child object.
After attaching child records to parent record, the new create field will show the SUM of the Amount field from the child records.
Thanks Dr Ganesh! Worked perfect!
Ricardo, I tried your way initially last week and it didn't work as the field I am rolling up is also a calculated field. But the javascript way worked for me noted by Dr Ganesh.
Thanks Guys.
Jeff
Thanks Ricardo.
Dr Ganesh & Ricardo, one more quick question on the rollup. How do I go about adding a filter to the javascript so I only rollup certain records. For example, all the line items with a pickilst field = a certain value...
Thanks
Jeff
Hi Jeff,
The syntax is:
#CALC_SUM.<relationship>( expression | condition ) or
#CALC_SUM.<field>( expression | condition )
The link below points you to the documentation:
documentation.progress.com/.../
Regards,
Ricardo
Thank you Ricardo, I seem to be still having an issue and can't wrap my head around this...
I have two objects Invoice and invoice line item. I need to SUM all of the "Hours" for all the line item records and display this field on the invoice object. However, I need to add a conditions for a file don invoice line item that Type (Picklist) value = "Consulting".
I'm trying this but doesn't work...
#CALC_SUM.R240954946 ( Hours | Type = "Consulting" )
R240954946 is my relationship name to invoice line items..
Below works fine and rollups up proper total of hours...
#CALC_SUM.R240954946(Hours)
But I need to add the condition to filter out values...