5 Replies Latest reply: Jun 16, 2016 6:53 AM by Carolin Borchert RSS

    Pivot chart Dimensionality error

    Carolin Borchert

      Hi,

       

      I´ve been working on the following statement within a pivot table. It is working in this way:

       

       

      = num(If((Dimensionality()=0),

      (sum({$<Next7DaysTotalHIS ={'1'}, OverallTransactionDate = {'$(=vToday)'}, OrderPhase_Desc = {'HISBACKLOG'}>}NettAmount$(vCurrency))),

       

      //If((Dimensionality()=1),

      //(sum({$<Next7DaysTotalHIS ={'1'}, OverallTransactionDate = {'$(=vToday)'}, OrderPhase_Desc = //{'HISBACKLOG'}>}NettAmount$(vCurrency))),

       

      If((Dimensionality()=2),

      (sum({$<Next7DaysTotalHIS ={'1'}, OverallTransactionDate = {'$(=vToday)'}, OrderPhase_Desc = {'HISBACKLOG'}>}NettAmount$(vCurrency))),

       

      (sum({$<Next7DaysTotalHIS ={'1'}, OrderPhase_Desc = {'HISBACKLOG'}>}NettAmount$(vCurrency))))),$(vInteger))

      //)

       

       

      but it is not working in this way when I :

       

       

      = num(If((Dimensionality()=0),

      (sum({$<Next7DaysTotalHIS ={'1'}, OverallTransactionDate = {'$(=vToday)'}, OrderPhase_Desc = {'HISBACKLOG'}>}NettAmount$(vCurrency))),

       

      If((Dimensionality()=1),

      (sum({$<Next7DaysTotalHIS ={'1'}, OverallTransactionDate = {'$(=vToday)'}, OrderPhase_Desc = {'HISBACKLOG'}>}NettAmount$(vCurrency))),

       

      If((Dimensionality()=2),

      (sum({$<Next7DaysTotalHIS ={'1'}, OverallTransactionDate = {'$(=vToday)'}, OrderPhase_Desc = {'HISBACKLOG'}>}NettAmount$(vCurrency))),

       

      (sum({$<Next7DaysTotalHIS ={'1'}, OrderPhase_Desc = {'HISBACKLOG'}>}NettAmount$(vCurrency))))),$(vInteger))

      )

       

      I believe that the mistake must be really small, something that I overlook right now...but I can´t find it...Does anybody see it?

       

      Many thanks for your help!

        • Re: Pivot chart Dimensionality error
          Sunny Talwar

          Can you try this may be:


          =If(Dimensionality() <= 2,

          Sum({$<Next7DaysTotalHIS ={'1'}, OverallTransactionDate = {'$(=vToday)'}, OrderPhase_Desc = {'HISBACKLOG'}>} NettAmount$(vCurrency)),


          Sum({$<Next7DaysTotalHIS ={'1'}, OrderPhase_Desc = {'HISBACKLOG'}>}NettAmount$(vCurrency)) )

          • Re: Pivot chart Dimensionality error
            Marcus Malinow

            Hi Carolin,

             

            I think one of your close parentheses at the end of your expression is in the wrong place.

             

            try this:

             

             

            = num(If((Dimensionality()=0),

            (sum({$<Next7DaysTotalHIS ={'1'}, OverallTransactionDate = {'$(=vToday)'}, OrderPhase_Desc = {'HISBACKLOG'}>}NettAmount$(vCurrency))),

             

            If((Dimensionality()=1),

            (sum({$<Next7DaysTotalHIS ={'1'}, OverallTransactionDate = {'$(=vToday)'}, OrderPhase_Desc = {'HISBACKLOG'}>}NettAmount$(vCurrency))),

             

            If((Dimensionality()=2),

            (sum({$<Next7DaysTotalHIS ={'1'}, OverallTransactionDate = {'$(=vToday)'}, OrderPhase_Desc = {'HISBACKLOG'}>}NettAmount$(vCurrency))),

             

            (sum({$<Next7DaysTotalHIS ={'1'}, OrderPhase_Desc = {'HISBACKLOG'}>}NettAmount$(vCurrency)))))),$(vInteger)

            )