Array search and compare

[#1]

Hello,

first sorry for my bad english, hope you understand me.

i have a table:

UserName	HList1	HList2
domain\username1	OK
domain\admin	OK	OK
domain\username2		OK

_

target:

Only the user with "OK" see the result.

If the Login Username equal Username in the table and Hlist value = OK, then show the result

Formel:

if ( Username = OSUSER()) and Hlist1 = 'OK', sum (XX))

what ist wrong?

thanks

[MayilVahanan]

HI

Try like this

if ( Username = OSUSER() and Hlist1 = 'OK', sum (XX),'')

[#3]

hello

thanks, but did not work

not work:

= if ( table.UserName = OSUSER(), sum (XXX),'')

work fine:

= if ( 'domain\username1' = OSUSER(), sum (XXX),'')

what is wrong?