2 Replies Latest reply on Mar 29, 2012 5:51 PM by 910769

    RWDerived Property fomula

    910769
      Trying to dynamically setup datastorage property for one of the hiers in DRM, where all parent will be tagged as NeverShare and any level zero member in the primary hier will be a store and level zero under alternate hier will be set to Shared. Not able to figure out to embed all these pieces together.

      The below formulas works as expected when worked seperately. Need some assistance on how I can combine these two.

      Primary hier

      If(And(Equals(integer,PropValue(Children),0),Equals(String,PropValue(CFHierValue),PRIM)),Store,Never Share)

      Alt hier

      If(Or(Equals(integer,PropValue(Children),0),Equals(String,PropValue(CFHierValue),ALT)),Share,Never Share)

      Thank you