Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I am working to create a KPI that compares the previous years results to the current selected year. The user will be able to pick a fiscal year from a filter pane and see the results. However I am having trouble when the first available year is picked (ex 2005) does not have a previous year to compare it to (no data for 2004) . Can the KPI display a text note when a previous year comparison is not available?
Here is my current expression
Sum({$<fiscal_year={$(=max(fiscal_year))}>} Tons) - Sum({$<fiscal_year={$(=max(fiscal_year)-1)}>} Tons)
Hi, maybe adding a condition to check if the firts year has been selected, something like:
If(max(fiscal_year)=min({1} fiscal_year), 'text note to display', [YourCurrentExpression])
Hi, maybe adding a condition to check if the firts year has been selected, something like:
If(max(fiscal_year)=min({1} fiscal_year), 'text note to display', [YourCurrentExpression])
Thank you for your response. Your expression help did the trick!