3 Replies Latest reply: Dec 13, 2013 8:47 AM by omar limon RSS

    doubt with NUM

      I everyone;

      I have a Bar graphic  with TWO dimentions and what I need to do is give inside of expression the next condition and format:

       

      if(CURRENCY_FILTRO='MXP',
      NUM(SUM(if(CURRENCY_FILTRO='MXP',(ventapesos)/1000,if(moneda='USD',(ventaoriginal/1000),(ventapesos/rate_usd)/1000))),'€#,##0;-€#,##0'),
      NUM(SUM(if(CURRENCY_FILTRO='MXP',(ventapesos)/1000,if(moneda='USD',(ventaoriginal/1000),(ventapesos/rate_usd)/1000))),'$#,##0;-$#,##0'))

       

      grafica3.jpg

       

       

      how it work?

      I have also one filter when I choose MXP I have the next format in the indicator: '€#,##0;-€#,##0'

      when I choose USD I have the next format in the indicator: '$#,##0;-$#,##0'

       

      BUT doesn't work why?

      Because I have TWO dimentions,,  Do exists someway to do or make this?

       

      If I use only one dimention work it perfect but I need two dimentions!!!

       

      Can you help me?

       

      grafica2.jpg