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