Query calculations

[KarimR]

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

[MFGF]

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.

[KarimR]

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