Text Object - return value from table when IF statement matches

[nigelapt]

Hi Folks

Hoping for some advice on a simple Text Object.

I have a simple table loading in from SQL with two fields, for example:

Group Name, Group Members

Domain Controllers, 300

SQL Servers, 1500

I just want to match the Group Name and return the number of Domain Controllers in a text box.

=if([Group Name]='Domain Controllers',[Group Members])

However it is just returning a hypen "-" 

Any advice would be appreciated.

Thanks

Nigel

[Taoufiq_Zarra · Accepted solution]

@nigelapt  Maye be :

=Only({<[Group Name]={'Domain Controllers'}>} [Group Members])

output :

[nigelapt]

Hi Taoufiq , thank you so much for taking time to help me.

Spent all morning searching for an answer and your's worked first time!

Many thanks

Nigel