Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I'm bulding a Pivot Table that tells me the monthly Average Elapsed Time of each resource (Workbook).
I have an option, that displays an arrow pinting up or down depending on an expression.
I need the expression that tells:
For each month: If the Average Elapsed Time of the previous month is lower ='fa-arrow-up'
See the picture attached.
Thanks.
Have you tried the Before() chart function?
Expression would be something like:
=if(Avg(Amount) > Before(Avg(Amount)), 'fa-arrow-up', 'fa-arrow-down')
It doesn't work...
Thanks!!
Can you share your QVF file?
Hello Torraroger.
Try the expression
Avg({<Month={'$(=Month-1)'}>} value) --> Considering that the months are numerals. If they are not, use month(date).
Hi Gui
Please assist me in the below expression to get previous months values.
SUM({<DateKey = {">=$(=Min({<FYP = {"$(=$(vCurrFYP))"}>} DateKey))<=$(=NUM(Date(vToday)))"}, FinancialCode =- {9999}, ProfitCentreCode = {2}, Date= >} RoomsSold)
Kind regards
Eugene