Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
HI
Try like this
if ( Username = OSUSER() and Hlist1 = 'OK', sum (XX),'')
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?