Hello All,
First time user of this platform!
I have a two segment subaccount each with two numerics like this 02-08 and need to create a generic inquiry that contains first two numerics of the first segment and the GL account number without the second segment.
For example, current subaccount string with GL account is 02-08-6115, I need the GI to show just 02-6115.
Would really appreciate help with this. Many thanks!
Best answer by BenjaminCrisman
So one option would be to just concatenate them together:
=Concat([Sub.SubCD_Segment1],'-',[Account.AccountCD])
+1You can use the LEFT and RIGHT string functions.
Left(GLAccount,3) - will return first two digits and dash.
Right(GLAccount,4) - will return last 4 digits.
You can then pull it together like this Left(GLAccount,3)+Right(GLAccount,4)
+4
So one option would be to just concatenate them together:
=Concat([Sub.SubCD_Segment1],'-',[Account.AccountCD])
I’ll be certainly using this forum again :-)
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
