2. PHPRunner General questions
  3. Formula for value
This topic is locked

Formula for value

 		10/24/2008 12:12:44 PM
PHPRunner General questions
F
 funkfish author

Hi there,
I have this fomula in excel "=AVERAGE(B15:AI15)+(AK15*0.25)-(AK15)"
How can I translate this into one of my $value= in the custom box?
Thanks in advance!

<img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=question&id=9959&image=1&table=forumtopics' class='bbc_emoticon' alt=':)' />
J
 		Jane 10/28/2008

Hi,
use Before record added and Before record updated events on the Events tab and PHP functions for this purpose.

All entered values are stored in the $values array, I.e. $values["FieldName1"], $values["FieldName2"], etc.