7 Replies Latest reply: Aug 25, 2011 7:08 AM by Onur Civelek RSS

    Define Ranges in Textboxes

      Hi together,

       

      how can simply define quality ranges ?

       

      I have a long formula like that calculate the qualitylevel from 0 to 100 

       

      = if (num(100 - (Count(DISTINCT{<FIELDVALIDATION={'invalid'}>}[HEL_DATA_Flight ID])/ count(DISTINCT [HEL_CAMPAIGN_Flight ID]) * 100),'0,000')

       

       

      How can i get a Textresult that depends on the value which was above calculated.

       

      Example: The above long term be variable X

       

      X      >     69       AND     X      <      93,31 Textoutput Qualitylevel sigma 2

      X      >     93,31  AND      X      <      99,31  Textoutput Qualitylevel sigma 3

      X      >     99,31  AND      X      <      99,97  Textoutput Qualitylevel sigma 4

       

      any idea ?

       

      Thank you !