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

Formula in Fields and get data from fields together

19 Views

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

U_Test & U_Test are numeric fields.

SELECT ($[INV1.U_Test.Number]-$[INV1.U_Test3.Number])*0.1

The outcome should be (U_Test-U_Test3)*0.1

U_Test2 & U_Test5 are alphnumeric fields.

SELECT $[INV1.U_Test2]+[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