2 Replies Latest reply: Sep 9, 2010 3:09 AM by Nikita Chumakov RSS

    Problem with set analysys when text variable contain space or special symbol

    Nikita Chumakov

      I can't figure out how can I overcome this issue.

      I have a variable (Top1) which determines the name of 1 top selling brand: =only({<Brand= {"=rank(sum(Sales), Brand) =1"}>} Brand )

      then this value is passed to textbox to get the sales for this top brand: =sum({$<Brand={$(Top1)}>}Sales),

      Formula works fine if Brand doesn't have spaces or special characters. Please see the screenshot for the results:

       

      error loading image