Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello guys
I have the following expression which gives me the chart below:
=
sum(ValorAçãoFechamentoAjustado)/
aggr(RangeSum(above(sum({<Month=, Date={'>=$(=MonthStart(Periodo, -1))<=$(=Date(Max(Periodo)))'}>} [Patrimônio Líquido]*1000/NumeroDeAções),0,90)),Periodo)
How can I color this blue line in green if it's above the average and in red if it's below the average?
For your reference, the red line is the average!
Thanks
Please post a sample Application.
I can guess this..
background color:
If([Column Name] > -0.75, Green(), Red())
Thanks for your attention...
The question is, you used 0.75 as a static number, based on what you saw at the picture, but we know that it may not be true, and the exact number is the average of the following expression:
=
sum(ValorAçãoFechamentoAjustado)/
aggr(RangeSum(above(sum({<Month=, Date={'>=$(=MonthStart(Periodo, -1))<=$(=Date(Max(Periodo)))'}>} [Patrimônio Líquido]*1000/NumeroDeAções),0,90)),Periodo)
So, my question is:
How can I calculate the average of the following expression?
Thanks
Bruno
Any help?
What is the Avg formula, you have used in the Chart?
This is what I'm asking for...
How can I calculate the average of the following expression:
=
sum(ValorAçãoFechamentoAjustado)/
aggr(RangeSum(above(sum({<Month=, Date={'>=$(=MonthStart(Periodo, -1))<=$(=Date(Max(Periodo)))'}>} [Patrimônio Líquido]*1000/NumeroDeAções),0,90)),Periodo)
Thanks