I have a simple growth rate equation that I'm displaying right now that I would like to limit. It is expressed as follows:
=num(
( sum( {$<FiscalYear= {$(=Max(FiscalYear))}>} Amount) - sum( {$<FiscalYear= {$(=Min(FiscalYear))}>} Amount) )
/
( sum( {$<FiscalYear= {$(=Min(FiscalYear))}>} Amount) * (Max(FiscalYear) -Min(FiscalYear)) )
, '#,##0%')
The problem is that I have one variable - SubContractor - which always goes to zero at the end of our time frame (FiscalYear), and that is correct, - it's not a problem. However, if someone were to select an entry in SubContractor, my growth rate would always, and correctly, display -100% growth. That's fine, but it's useless. I would simply like to display "N/A" in place of the growth rate when someone adds an entry from SubContractor to the current selections.
