where the [UserID] field matches the OSUser()

[wynnjimbbt]

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())

[sunny_talwar · Accepted solution]

May be this?

=If(UserID = SubField(OSUser(), '\', -1), 1, Null())

[wynnjimbbt]

Thank you!