Skip to Content
0
Former Member
May 08, 2008 at 08:49 AM

Formula in Fields and get contents form different fields together

16 Views

Hi, I was trying to setup formula in fields as follows:

U_Test & U_Test are numeric fields.

SELECT ($http://INV1.U_Test.Number-$http://INV1.U_Test3.Number)*0.1

The outcome should be (U_Test-U_Test3)*0.1

U_Test2 & U_Test5 are alphnumeric fields.

SELECT $http://INV1.U_Test2+http://INV1.U_Test5)

The outcome should be U_Test2U_Test5

I have been struggling in the syntax error. Can you help me out?

Thanks.

Raymond