Copy link to clipboard
Copied
Hi, i need with this script please:
Field names: Box1, Box2, Box3, Box4, Box5, Box6, Box7, Box20
Box4 is total from Box20
Box3 = Subtract Box2 from Box1
Box5 = Subtract Box4 from Box3
Box7 = add Box5 and Box6
Now whats script to add in Box4, Box3, Box5, Box7 and where? Thanks!!!!
Copy link to clipboard
Copied
Answer in picture, you don't need any script:
Copy link to clipboard
Copied
It works thanks
Copy link to clipboard
Copied
You don't need any scripts. Use the Simplified Field Notation option in the Calculate tab and simply write out the formulas for each field, like this:
For Box4:
Box20
For Box3:
Box1 - Box2
For Box5:
Box3 - Box4
For Box7:
Box5 + Box6
Copy link to clipboard
Copied
Thanks!!! it works