0 Replies Latest reply: Oct 26, 2016 8:02 AM by Ilse Beldman RSS

    Expression editor: set analysis on two dimensions within a variable

    Ilse Beldman

      Hi all,


      Our dashboard makes use of the variable vFormatNumberDec with the definition:

      Dual(Num(ROUND($1)/Pow(10,3*$(vSize($1))),only(CurrencySymbol)&' ###')&' '&Pick($(vSize($1)),'k','M','B','T'),$1)

      The variable vSize is defined by: Div(Log10(FABS($1)),3)


      Which adds a currency sign (dimension CurrencySymbol) and a scale name (k/M/B/T) dependent on the size of the number.

      An example:



      sum({<OCFColumnName1=>}-[Fact: Financial] * Flag_ROLL * Flag_Direct_Costs * Flag_Has_Actuals)

      with the result: € 2.31 B.


      The above example makes us of a set analysis with a single dimension.


      But it gives errors when we use multiple dimensions like:


      SUM({<Region=, RegionCountry=, Worldview=>} [Fact: Financial] * [Flag_Revenue] * [Flag_ACT] * [Flag_Has_Actuals])


      Does anybody have a soloution for our problem?