Search found 1 match
- Wed Jan 22, 2003 10:39 am
- Forum: R&R ReportWorks Users
- Topic: IF, THEN, ELSE
- Replies: 1
- Views: 1023
IF, THEN, ELSE
How can I check a field value and then multiply another field by 2 if it is the value I want? For example: I want to check if a value = 41, if it does then I want to multiply a corresponding field by 2 - I have tried - IIF (TEST_ID = 41, QTY*2), where test_id and qty are two different fields. I keep...