Joined: 22 Jan 2013
Online Status: Offline
Posts: 89
Topic: If IsNull Then........? Posted: 08 Nov 2013 at 12:21pm
I can't figure out what I am doing wrong with my (). I want address type M1 phone number only when there is no term date, else I want R1 phone number with no term date.
ORIG WAS DOING THIS:
if ({MEMBER_ADDRESS.ADDRESS_TYPE} = 'M1') and
isnull({MEMBER_ADDRESS.TERM_DATE})then
{MEMBER_ADDRESS.HOME_PHONE_NUMBER}
else
if ({MEMBER_ADDRESS.ADDRESS_TYPE} = 'R1') and
isnull({MEMBER_ADDRESS.TERM_DATE})then
{MEMBER_ADDRESS.HOME_PHONE_NUMBER}
else
"Blank"
THEN WE TRIED THIS....
If ((IsNull ({MEMBER_ADDRESS.TERM_DATE}) and
{MEMBER_ADDRESS.ADDRESS_TYPE} = 'M1')) then
{MEMBER_ADDRESS.HOME_PHONE_NUMBER}
else
If ((IsNull ({MEMBER_ADDRESS.TERM_DATE}) and
{MEMBER_ADDRESS.ADDRESS_TYPE} = 'R1') then
"Blank"
Joined: 21 Dec 2007
Online Status: Offline
Posts: 4372
Posted: 08 Nov 2013 at 12:27pm
are these on the same line of data or different lines?
Formulas only work on 1 line at at time.
The line might be from different tables, but as far as seeing the results in something in like SQL Manager, it would all be on one line.
I only ask in that how can 1 field have different values, as in if the type is M1 or R1...this implies different records. Shared variables and displaying the results in the group footer make more sense.
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum
IP Logged
