wynnjimbbt
Contributor III
2019-11-15
10:35 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
where the [UserID] field matches the OSUser()
I need a calculated dimension to suppress Nulls where the [UserID] field matches the OSUser() value
I have a syntax issue below:
This works in a text box:
=if(Sum({$<UserID = {'$(=SubField(OSUser(), '\', -1))'}>} [Total Revenue])>0,1,0)
I need the below to return a 1 or Null(); and to suppress Nulls:
=if({$<UserID = {'$(=SubField(OSUser(), '\', -1))'}>},1,null())
1,684 Views
1 Solution
Accepted Solutions
sunny_talwar
MVP
2019-11-15
11:08 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
2 Replies
sunny_talwar
MVP
2019-11-15
11:08 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
May be this?
=If(UserID = SubField(OSUser(), '\', -1), 1, Null())
wynnjimbbt
Contributor III
2019-11-15
11:24 AM
Author
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Thank you!
1,676 Views