13 Replies Latest reply: Feb 8, 2016 11:30 AM by Riccardo Schillaci RSS

    Formula Inside Set Analysis

    Riccardo Schillaci

      Hi,

       

      I want to use this expression:

       

      =Only({<ATYPE={'VALUETYPE'},NUM_FROM={"<=1"},NUM_TO={">=1"}>} NUM_RESULT)

       

      This is working fine, NUM_RESULT is the right value that I'm expecting from a between check (1 is between NUM_FROM and NUM_TO).

       

      Now, I want to replace this 1 with a formula like this:

       

      =avg({<BTYPE={'ANOTHERTYPE'},YEAR=P(Year)>} VALUE_PERC)

       

      (I'm using this fomula in a pivot column, I can use also the column alias as field)

       

      it works as a new pivot column, but If I replace the 1 with this, it doesn't work. I tried also with variables but it doesn't work.

       

      I tried:

       

      =Only({<ATYPE={'VALUETYPE'},NUM_FROM={"<=$(vartest)"},NUM_TO={">=$(vartest)"}>} NUM_RESULT)

       

      where vartest is

      avg({<BTYPE={'ANOTHERTYPE'},YEAR=P(Year)>} VALUE_PERC)

       

      Thank you, best regards.

      Riccardo