7 Replies Latest reply: Apr 10, 2017 11:35 AM by John Repucci RSS

    Set analysis fails in v12.10 SR4

    John Repucci

      Did Set Analysis syntax change in v12?

      This simple expression evaluates as bad in v12.10 SR4 and evaluations as good in v11.20 SR9.

      Where vInc.OpenPO is set in the Settings / Variables to Year = {'2017'}

      V11-expression.PNGV12-expression.PNG

      When I change the expression to =Sum({< Year = {'2017'} >} Value) in v12, the expression evaluates as correct.

       

      Puzzled,

      John

        • Re: Set analysis fails in v12.10 SR4
          Anil Babu Samineni

          This is bug in v12.10 SR4. But, Output will give same as i noticed earlier. 11.20 is considering as Expression but QV12 get it as simple expression with error. They are working on it for next release version

            • Re: Set analysis fails in v12.10 SR4
              John Repucci

              Anil,

              thanks for the response and confirmation that it is a bug.

              • Re: Set analysis fails in v12.10 SR4
                John Repucci

                However, when using my production expression, I do not get the right answer.

                 

                This expression, which uses $(vInc.OpenPO) in the set analysis, returns a null()

                =IF(vCurrencyType = 'USD',

                  Num(IF(vShowOpenPO = 1,

                  Sum(EntryValue)+Sum( {< $(vInc.OpenPO) >} POAmount ),

                  Sum(EntryValue)),'$#,##0.00;($#,##0.00)'),

                  IF(vCurrencyType = 'EUR',

                  Num(IF(vShowOpenPO = 1,

                  Sum(EntryValue)+Sum({<$(vInc.OpenPO)>}POAmount),

                  Sum(EntryValue)),'€#,##0.00;(€#,##0.00)'),

                  Num(IF(vShowOpenPO = 1, // if not USD or EUR, display w/out a currency symbol

                  Sum(EntryValue)+Sum({<$(vInc.OpenPO)>}POAmount),

                  Sum(EntryValue)), '#,##0.00;(#,##0.00)')

                  )

                  )

                 

                This expression, where I've replaced $(vInc.OpenPO) in the set analysis with POStatus = {'Open'}, gives the expected values.

                 

                =IF(Currency = 'USD',

                  Num(IF(vShowOpenPO = 1,

                  Sum(EntryValue)+Sum({< POStatus = {'Open'} >} POAmount ),

                  Sum(EntryValue)),'$#,##0.00;($#,##0.00)'),

                  IF(Currency = 'EUR',

                  Num(IF(vShowOpenPO = 1,

                  Sum(EntryValue)+Sum({<POStatus = {'Open'} >}POAmount),

                  Sum(EntryValue)),'€#,##0.00;(€#,##0.00)'),

                  Num(IF(vShowOpenPO = 1, // if not USD or EUR, display w/out a currency symbol

                  Sum(EntryValue)+Sum({<POStatus = {'Open'}>}POAmount),

                  Sum(EntryValue)), '#,##0.00;(#,##0.00)')

                  )

                  )