-
1. Re: ISNULL shows as a value other than NULL
Zhouyi ZhangJan 17, 2018 10:02 PM (in response to Brian Fornelius)
Hi, Brian
Can you show some sample data from both Excel and MYSQL as well as how you do the join?
ZZ
-
2. Re: ISNULL shows as a value other than NULL
Brian Fornelius Jan 24, 2018 8:23 AM (in response to Zhouyi Zhang)the data works... I'm just trying to figure out how to get it to display inthe summary differet.
{FIXED : MAX(
IF = 1
AND ISNULL()
THEN ()
ElSE NULL
END
)}
I have the above and then the oppposite where contact = 1. How I want it to display in the reports is a 'Y' or 'N'
For the ones that are ISNULL I would like it to show 'N' instead of Null. and for the ones where contract = 1 I would like it to display as 'Y'
So the output of the below would have a 'N' instead of Null..
Sent from Outlook<http://aka.ms/weboutlook>
-
image.png 3.5 KB
-
-
3. Re: ISNULL shows as a value other than NULL
Zhouyi ZhangJan 28, 2018 7:10 PM (in response to Brian Fornelius)
Hi, Brian
I am not quite sure what are you talking about your formula and you screenshot just doesn't have enough information to help. but general speaking, you can always try below
if isnull(your measure) then "N" else "Y" end
Hope this could help
ZZ