
Re: Expersion if a month is selected and if more than one is selected??
jonathan dienst May 20, 2012 8:10 AM (in response to javierortiz )Hi
Don't know your data model of course, but perhaps TC = Avg(TC) when Mes = 1? In that case you don't need two sets of expressions, just
sum([Desv Abs])/Avg(TC)/1000
and
sum([Total períodos de informe])/Avg(TC))/1000
Regards
Jonathan

Expersion if a month is selected and if more than one is selected??
javierortiz May 20, 2012 1:51 PM (in response to jonathan dienst )Hi jonathan, thanks for your reply, but, I really need this conditions, if I select just one month I need the fisrt 2 IF statements if more than one month is selected I need the Second statement.

Expersion if a month is selected and if more than one is selected??
Ravi Gantyada May 20, 2012 2:10 PM (in response to javierortiz )Hi Bosssssss
can you try this condition
=if(GetPossibleCount(Mes) = 1 ,
if(EDO_FIN = 'RESULTADOS', ((sum([Desv Abs])/TC)/1000),
if(EDO_FIN = 'BALANCE', ((sum([Total períodos de informe])/TC)/1000))),
if(GetPossibleCount(Mes) <> 1,
(if(EDO_FIN = 'RESULTADOS', ((sum([Desv Abs])/Avg(TC))/1000),
if(EDO_FIN = 'BALANCE', ((sum([Total períodos de informe])/Avg(TC))/1000),0)))))


Hi Guys, I have this expresion in a bar chart:
=if(Count(DISTINCT Mes) = 1 ,
if(EDO_FIN = 'RESULTADOS', ((sum([Desv Abs])/TC)/1000),
if(EDO_FIN = 'BALANCE', ((sum([Total períodos de informe])/TC)/1000),
if(EDO_FIN = 'RESULTADOS', ((sum([Desv Abs])/Avg(TC))/1000),
if(EDO_FIN = 'BALANCE', ((sum([Total períodos de informe])/Avg(TC))/1000),0)))))
Mes means Month, what I need is that if I select just one month gives me the first 2 IF statements, and if more than one month is selected gives me the send pair of IF statement, I attahced the app for a better understand.
Any Ideas??
Thank you all!!