Set Analysis with an expression

[paul_ripley]

Hello

I have some data and I would like to limit the entities and account codes within that data that are brought back.

An example of a basic expression on my data which works is

sum ( {  <account = {'1101'}, Entity  = {'0415'}> } gl_amount)

What I really want is to show all 1* accounts and all entities either  <'0900' or <'A0900'

I tried using wildmatch for the account and failed and also not sure how to limit the entities

any help would be appreciated

Thanks

Paul

[pokassov]

Something like this?

sum ( {$<account = {'=1*'}, Entity  = {'<*0900'}>} gl_amount)

[jolivares]

You must user "

sum ( {$<account = {'=1*'}, Entity  = {"<0900"}+ {"<A0900"}>} gl_amount)

[stigchel]

Think the <*0900 or <A0900 do not work? Maybe something like

sum ( {$<account = {"=1*"}, Entity  = {"=Keepchar(Entity,'0123456789')<900"}>} gl_amount)

[sunny_talwar]

Can you share some sample data to check out how exactly the data look?

[paul_ripley]

Hi All

Thanks for your help

I couldn't get it to work but it is possibly my data so I will continue to investigate

Kind regards

Paul