How can I insert an average here? - Qlik Community

brunolelli87 · ‎2020-05-02

Dears,

How can I insert an average into the following formula:

=num(FirstSortedValue(ValorAçãoFechamentoAjustado, -DataCotação), 'R$ 0,00')

I'm trying something like:

=num(avg(FirstSortedValue(ValorAçãoFechamentoAjustado, -DataCotação)), 'R$ 0,00'), but it's not working...

Thanks!

Saravanan_Desingh · ‎2020-05-02

Can you try like this?

=Num(RangeAvg(FirstSortedValue(ValorAçãoFechamentoAjustado, -DataCotação)), 'R$ 0,00')

brunolelli87 · ‎2020-05-03

Thanks for your assistance, but it's not working...

It's showing a dash, -

Brett_Bleess · ‎2020-05-26

Would likely be most helpful if you can attach small example QVW file on this one, not sure anyone can be sure otherwise. This will kick things back up too given you posted on a Saturday, it likely got missed by a lot of folks.

Regards,
Brett

To help users find verified answers, please do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question.
I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.