6 Replies Latest reply on Oct 31, 2018 10:37 AM by maneesh.gaddam

    Fixed by one dimension, if at least one sub dimension = something, then assign fixed dimension....

    Raza Asghar

      I have a data set with unique display locations, each of which contain at least 1 ITEM ID. Each ITEM ID is either considered "Y" meaning its AGING, or "N" meaning its NOT AGING.

       

      I want to create a calculated field whereby if a Display Locn has AT LEAST 1 ITEM ID that is considered "Y", then the overall output for that Display Locn is "AGING". If not, meaning, all of a Display Locn's Item IDs are "N", like (display locn 9201 & 8483), then the Display Locn would get a "NON AGING" output.

       

      How can I do this? I'm stuck at the {FIXED: Display Locn} part, because I'm not sure how to tell a calculated field to check all of a dimension's sub dimensions aka Item IDs for a specific dimension (Y or N) and if it finds at least one that is "Y", then output "AGING" (display locn 1005 and 4003).

       

      Display Locn

      Item ID

      Aging

      OUTPUT

      1005

      82949

      71920

      Y

      Y

      AGING

      4003

      09190

      18198

      84820

      N

      N

      Y

      AGING

      9201

      9288

      0192

      N

      N

      NON AGING

      84838283NNON AGING

       

      Thank you!