This content has been marked as final. Show 19 replies
I'm struggling to identify where the error is occurring in the following expression:
=Month(max(Date)) & ' vs ' & Month(max(Date)-31) & chr(10) & 'Spending' & chr(10) &
num(fabs($(vMonthSpending) - $(vLastMonthSpending) / $(vMonthSpending)), '(##.00%)')
I'm trying to get a text output of a selected month vs. last month's spending increases as a percentage.
Here is the expression for the Year vs. Last Year spending increase that executes successfully:
=max(Year) & ' vs ' & (max(Year)-1) & chr(10) & 'Spending' & chr(10) &
num(fabs($(v2017Spending) - $(v2016Spending) / $(v2017Spending)), '(##.00%)')
Any advice or assistance is much appreciated.