I realise that the arithmetic within Xataface can be a little flakey..but for what I need, I've found it to be cool. Result
I guess a grafted field of some sort may be required but I've got a "simple" calculation to do and was wondering the best way.I'd like to multiply a column from the first table with a column from the second table and produce the output as a column in the second table.
e.g
within Table2/Table2.php
Table1.Price1*Table2.Price2 and then display it AS Table2.TotalPrice
Can you advise on the best way?
Thanks loads.