I am using the following statement to give occurrences a numerical value but when I pull into Excel it identifies it as text. How do I get it to send the data to Excel as a number? Fixing manually in Excel is not an option. Here is my statement:
(CASE WHEN
[Loans].[LN Master].[Participation Code (LNMA)] IN ('s','S')
THEN
'1'
ELSE
'0'
END)
I appreciate any assistance.
Thanks,
Ariana
Quote from: Ariana on 06 Jul 2016 02:19:50 PM
I am using the following statement to give occurrences a numerical value but when I pull into Excel it identifies it as text. How do I get it to send the data to Excel as a number? Fixing manually in Excel is not an option. Here is my statement:
(CASE WHEN
[Loans].[LN Master].[Participation Code (LNMA)] IN ('s','S')
THEN
'1'
ELSE
'0'
END)
I appreciate any assistance.
Thanks,
Ariana
Hi,
Have you tried:
(CASE WHEN
[Loans].[LN Master].[Participation Code (LNMA)] IN ('s','S')
THEN
1
ELSE
0
END)
MF.
:o Thank you so much! You would be amazed how many people tried to fix this and failed at my place of business. In retrospect, it is all kind of silly.
Quote from: Ariana on 07 Jul 2016 10:22:39 AM
:o Thank you so much! You would be amazed how many people tried to fix this and failed at my place of business. In retrospect, it is all kind of silly.
Happy we could help! Let's hope it earns you some kudos at work for being the one to solve it :)
MF.