1 Reply Latest reply: Aug 11, 2014 11:43 AM by GlennS_3 RSS

    Account Member Formulas

    983332

      Is there a way to use wild cards in member formulas for the following where Account = "1100??" and Custom Dimension = "9?"

       

      "1100??" - "11007?"

      "1100??"->"9?" - "11007?"->"9?"

       

      Instead of typing all the combinations for ??, is there a way to use wild cards?

       

      "110000" - "110070"

      "110001" - "110071"

      so on so forth

       

      "110000"->"90" - "110070"->"90"

      "110001"->"90" - "110071"->"90"

      so on so forth

        • 1. Re: Account Member Formulas
          GlennS_3

          TThere is not an easy way to do it. You can look at the substring concatinate name and member functions. To possibly get what you want you use a custom defined functIon. Or since these are member formulas you might consider creating the formulas in excel and use a dimension build rule to load them in

          m