Is there a way to use a Dictionary Entry Calculated value to total a related list

[Christopher Dan]

I have a related list on a form that I need a currency column to total up to a field on the form. I want to use a Dictionary Entry Calculate Value to total so it totals instantly without an update to the record of the related list. Is this possible?

[ghsrikanth]

I doubt onchange will trigger for the calculated field,

You can write a simple onChange script for the actual cost field and print an alert statement and see if changing the values on the forms, will trigger the onchange or not.

[Christopher Dan]

which table would I put it on? and what other way could I get it to update correctly if I don't use a onchhange script?

[ghsrikanth]

I have just constructed a table in my local instance,

Two variables

Name // this variable holds the name

Calculated Name //this variable is calculated which gets value from the Name field

Ex:

Name = Chris

Calculated Name gets calculated to value = Hi Chris

Written a before BR which triggers on Calculated Name field

On updating the Name field with Chris Danko

Calculated Name gets calcualted to value = Hi Chris Danko

The BR is triggering

So I am not sure now, why the BR that you have written on the Work Order Cost on change of Actual Cost is not triggering.

If its your developer instance, I can help you in debugging by logging inside.

[Christopher Dan]

it is my Dev instance

[ghsrikanth]

Cool, can you create a new user like

Username: admin2

Password: Test@123

Give the user admin role, give me details of the tables, I will try to take a look into it