Skip to Content
0
Mar 20, 2009 at 01:45 PM

Formatted Search using SUM

78 Views

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