3 Replies Latest reply: Oct 5, 2011 9:26 AM by Onur Civelek RSS

    Filtering in Diagrams with variables

      Hello QV-Community,



      I would like to use a if expression to write a value from a variable. The variable is already defined in the variable window and has the current value of 0.
      Now, when I write my formula expression with a 0, it works perfect.

       

      Like this:

       

       

      =if

          (

           ( min(date#(HEL_DATA_Datum,'DD.MM.YYYY')) - min (SAL_OPPORTUNITYLINEITEM_von_Datum__c)) = 0 ,

           ( min(date#(HEL_DATA_Datum,'DD.MM.YYYY')) - min (SAL_OPPORTUNITYLINEITEM_von_Datum__c)),

           'x'

          )

       

       

       

      However when I try to replace the 0 by a variable (varLimit) it doesnt work !!

       

      Like this:

       

       

      =if

          (

           ( min(date#(HEL_DATA_Datum,'DD.MM.YYYY')) - min (SAL_OPPORTUNITYLINEITEM_von_Datum__c)) = $(varLimit) ,

           ( min(date#(HEL_DATA_Datum,'DD.MM.YYYY')) - min (SAL_OPPORTUNITYLINEITEM_von_Datum__c)),

           'x'

          )

       

      What am I doing wrong here ? Please give me a tip. Thank you.