Hi all,
For my internship, I need to continue building a query in Report Studio, which the last intern already started. To continue with where she left, I first need to understand how she got to the point that she left.
One of the query calculations is: if ([GL Account] like '83%') then ('Unrealized') else ('Realized'). The expressions itself is not complicated, but I am wondering what exactly the 83% is, since the GL Accounts are for example 830101, 830102, 841620.... How is it possible to compare a number like that to 83%. I have been Googling it as well, but could not find an answer, so I hope one of you guys could help me out.
Thanks in advance,
Karim
Quote from: KarimR on 21 Sep 2015 06:46:08 AM
Hi all,
For my internship, I need to continue building a query in Report Studio, which the last intern already started. To continue with where she left, I first need to understand how she got to the point that she left.
One of the query calculations is: if ([GL Account] like '83%') then ('Unrealized') else ('Realized'). The expressions itself is not complicated, but I am wondering what exactly the 83% is, since the GL Accounts are for example 830101, 830102, 841620.... How is it possible to compare a number like that to 83%. I have been Googling it as well, but could not find an answer, so I hope one of you guys could help me out.
Thanks in advance,
Karim
Hi,
I'm assuming here that the GL Account item has a character datatype? If so, the % character here is likely a wildcard, so the expression is asking for any rows whose GL Account value starts with the characters 83 (in your example this would include 830101 and 830102 but not 841620)
Cheers!
MF.
Hey,
Thanks for your fast reply and I finally got it, you are right. I really thought I had checked that as well, but aparantly I didn't look carefully...stupid me.
Thanks again,
Karim