4 Replies Latest reply on Oct 24, 2016 7:55 AM by David Li

    How do I create a calc. field to indicate when String is not present within the Dimension's partition


      Is it possible to search for String that IS NOT within a particular partition?


      For example, I would like to create a Dimension that would identify whether the [Status] of "L2" was not showing in the partition.  The screenshot below shows statuses without "L2" so the calculated field would say something like "No" (where "L2" [Status] is absent) or "Yes" (where it is present).


      Hope this screenshot gives enough of an idea of what I'm trying to achieve - unfortunately I cannot upload the twbx.