Solved
If Then Else Then Sum
Posted on 2009-04-15
I have this criteria - where Table.FieldA does not equal 'I' then 1 else 0. Then sum the information from Table.FieldB based on the If/Then statement. I have a report where I need to put in the information for the opposite information, too - where Table.FieldA does equal 'I' then 1 else 0 and so on.
If {Table.FieldA} <> 'I' Then 1 Else 0 Then Sum ({Table.FieldB}). When I do this I get a "the ) is missing" message box and it highlights "Then" when this happens.
How do I correctly state this formula? Thanks.