I have a user defined field called U_PRPrice which I want to be a Formatted search populated by the result of another udf U_SPrice divided by 12 and multiplied by a udf U_PRMNTH
I can get the formatted search to fire by using
SELECT SUM (T0.[U_SPrice]/12 *T0.[U_PRMNTH]) FROM OINS T0
however I am struggling to pass through the dynamic values from the active record card using the $[$OINS.U_SPrice] parameter
Can anyone point me in the right direction before I throw myself out of the window!
Thanks