I'm new to Web Query; I only got the program a couple of weeks ago. Now they want me to build a report for a client. I'm having a problem with a Define field. The field should return a sum of three fields if the IF statement is true.
IF ( TXDIS5.TXDIS5.YEARTMP LT 2012 ) AND ( TXDIS5.TXDIS5.FNDCODETMP EQ 'M&O' ) THEN TXDIS5.TXDIS5.TAXCOLTMP + TXDIS5.TXDIS5.PNICOLTMP + TXDIS5.TXDIS5.FEECOLTMP ELSE 1
I've put the Define field in the report and can see one row with amounts in each of the fields in the formula; but the field returns 0.00. What am I doing wrong?