Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dears,
I have a chart with
Dimensions = Stickers and,
Expression =num(avg([P/L]), '#.##0,00;-#.##0,00')
So, the user can select some Stickers, as dimensions, and I would like that, if just one Sticker is selected, the system should show 2 bars, the one related to the expression, and another one with the following formula: "=num(avg({<Sticker,SubsetorEmpresa=p(SubsetorEmpresa)>}[P/L]),'#.##0,00;-#.##0,00')"
I'm trying to use the conditional function with the following formula:
"= IF(GetSelectedCount(Sticker) > 0, 1, 0)", but it's not working properly..
How can I do it?
Thanks
Bruno Lelli
I found a way to solve it...
On condition field:
GetSelectedCount(Sticker) = 1
On expression field:
=num(avg(TOTAL {<Sticker,SetorEmpresa=p(SetorEmpresa)>}[P/L]),'#.##0,00;-#.##0,00')
Thanks guys!
On the second expression, use the condition:
= IF(GetSelectedCount(Sticker) > 0)
It's not working
What do you mean by the second expression?
Please, check the picture...
I found a way to solve it...
On condition field:
GetSelectedCount(Sticker) = 1
On expression field:
=num(avg(TOTAL {<Sticker,SetorEmpresa=p(SetorEmpresa)>}[P/L]),'#.##0,00;-#.##0,00')
Thanks guys!