Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!!
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
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
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.
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)))))