topic Re: expression based on filter and osuser in App Development

expression based on filter and osuser

joeybird — Mon, 18 Jul 2016 14:57:32 GMT

I only wish to sum on person logged in

I have a text box that shows show's who's logged in via a windows login using

domain = OpenWorld

Username =jo111111

on text box expression is

osuser()

this gives me UserDirectory=OpenWorld;UserId=jo111111

I have a filterpane called UserId that contains jo111111

there is a chart showing sales, my expression is like this, but it does not work I only wish to sum on person logged in

sum ({$<OSUser= {UserID}>}SALES)

how can I get this to work please

Re: expression based on filter and osuser

sunny_talwar — Mon, 18 Jul 2016 15:00:22 GMT

How about this:

Sum({$<UserID = {'$(=SubField(OSUser(), '=', -1))'}>}SALES)

Re: expression based on filter and osuser

joeybird — Tue, 19 Jul 2016 09:22:35 GMT

fab , thank you x

Re: expression based on filter and osuser

sunny_talwar — Tue, 19 Jul 2016 09:45:45 GMT

No problem at all

Re: expression based on filter and osuser

joeybird — Fri, 12 Aug 2016 14:12:27 GMT

sorry I am having issues using this expression with {$<UserID = {'$(=SubField(OSUser(), '=', -1))'}>}, this does not seem to work within use of an IF statement, how can it please be amended?

count({$<UserID = {'$(=SubField(OSUser(), '=', -1))'}>}CustID)

also I have a table on a sheet...this gives me 0 or 1, how can I then limit the count to 1 on the table please?

Please help

Re: expression based on filter and osuser

sunny_talwar — Fri, 12 Aug 2016 14:14:04 GMT

Within the if statement? Can you share the expression you are trying to use?

Re: expression based on filter and osuser

joeybird — Fri, 12 Aug 2016 14:21:28 GMT

here is the IF statement

if(DFlag = 'No', MODE({$<[Country] ={"France"}, Department_Number = {1}, UserID = {'$(=SubField(OSUser(), '=', -1))'}>}Sales), mode({$<[Country] ={"France"}, Department_Number = {2}, UserID = {'$(=SubField(OSUser(), '=', -1))'}>}Sales))

please help

Re: expression based on filter and osuser

joeybird — Mon, 15 Aug 2016 07:58:29 GMT

please see below

please help

Re: expression based on filter and osuser

sunny_talwar — Mon, 15 Aug 2016 09:15:40 GMT

Can you try this:

If(DFlag = 'No',

Mode({$<[Country] = {'France'}, Department_Number = {1}, UserID = {"$(=SubField(OSUser(), '=', -1))"}>}Sales), Mode({$<[Country] = {'France'}, Department_Number = {2}, UserID = {"$(=SubField(OSUser(), '=', -1))"}>}Sales))

Re: expression based on filter and osuser

joeybird — Mon, 15 Aug 2016 13:42:55 GMT

this worked, issue still with table chart on a sheet. any ideas please? I have tried to use a flag, but no joy.

Re: expression based on filter and osuser

sunny_talwar — Mon, 15 Aug 2016 13:44:34 GMT

Issue with "table chart on a sheet"? Not sure what we are talking about here?

Re: expression based on filter and osuser

joeybird — Mon, 15 Aug 2016 13:46:15 GMT

I have used below

count({$<UserID = {'$(=SubField(OSUser(), '=', -1))'}>}CustID)

on table on a sheet...this gives me 0 or 1, how can I then limit the count to 1 on the table please?