Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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'))
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?
TRy to create two graph (clone) without if condition on CURRENCY_FILTER,
and use Conditional Layout on
Graph MPX:
CURRENCY_FILTER='MPX'
Graph USD:
CURRENCY_FILTER='USD'
Hello Omar, Check your then and else parameters; they are exactly the same...
Alberto
Hi Alberto good moorning;
It's Correct they are the same buecause when Currency filter = 'MXP' then will show the same resut with format;'€#,##0;-€#,##0' ...If Currency filter = 'USD' then will show the same result but how with format: '$#,##0;-$#,##0'