2. PHPRunner General questions
  3. [SOLVED]  Doing Math in PHPRunner
This topic is locked
[SOLVED]

 Doing Math in PHPRunner

 		11/1/2019 7:26:21 AM
PHPRunner General questions
gehrenfeld author

I find it very difficult to do math functions in PHPRunner.
With PHP I would just do:

$total = $hours $regular;

$tax = $total $fed

and so forth.

$reguler and $fed are in a different table than $hours
I can then echo them.
I can figure out how to do that with PHPRunner.

If I can do this in events, how would I do that?
Thanks
HJB 11/1/2019

https://xlinesoft.com/phprunner/docs/query_designer.htm

is what showing you need, namely CALCULATIONS.
The Youtube Video: https://www.youtube.com/watch?v=4x7yR8oQHpM

is further providing useful information on calculations and

field formatting isues. Wished "from different tables field

calculations" is explained nearly at the end of the video.
What you see inside that very video, here the jumping between

SQL and RESULTS tab, is directly the same you see under PHPR

section QUERY and subsequent SQL / RESULTS tabs inside that

very QUERY section, so you can easily reference things.
gehrenfeld author 11/2/2019

That is what I needed.
Thank you