Set Analysis NTNAME=OSUser()

[zagzebski]

I am trying to write a set analysis expression that analyzes whether the NTNAME given is = to the OSUser(). It doesn't work - just keeps giving the total amount for every line whether the NTNAME = OSUser() or not.

sum ({$<NTNAME=OSUser()>} AMT)

Steve

[#2]

Steve,

try:

sum ({$<NTNAME={"=OSUser()"}>} AMT)

or

sum ({$<NTNAME={'$(=OSUser())'}>} AMT)

[its_anandrjs · Accepted solution]

Try to write like

=Sum ({<NTNAME={ '$(=OSUser())' }>} AMT)

Or

=Sum ({$<NTNAME={ '$(=OSUser())' }>} AMT)

Or

=Sum ({$<NTNAME={ "$(=OSUser())" }>} AMT)

Or

=Sum ({$<NTNAME={ "$(=OSUser())" }>} AMT)

[trey_bayne]

What happens if you put =OSuser() in a text box?

[SunilChauhan]

may be

youcan use below

sum ({$<NTNAME={$(=Upper(OSUser()))>} AMT)

hope this helps

[maxgro]

=sum({$ <NT_NAME={"$(=OSUser())"}>} AMT)

check the domain is present in NT_NAME and OSUser()

or

not present in NT_NAME and not present in OSUser()

[Miguel_Angel_Baeyens]

Hey,

Take into account that NTNAME is a reserved field name for section access and not visible from the model. If you want to compare current user returned by OSUser() with any other field that stores the user, make sure you are loading them in a field named different to NTNAME, otherwise, it will not work.

Miguel