Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi, I'm using set analysis combined a Linear Gauge mini chart. However, I'm having an issue with the lower bound (i.e., if the value is less than zero, my chart will not draw). I was able to get the Max bound set using the following logic:
If(vComparePeriod = 'Year',
max(total aggr((Sum({$<FiscCalYr={'$(CurrentYear)'}>} ReportedPrice) / Sum({$<FiscCalYr={'$(PreviousYear)'}>} ReportedPrice)) -1, grpCGeoPartnerProduct)),
If(vComparePeriod = 'Quarter',
max(total aggr((Sum({$<FiscCalYr={'$(CurrentYear)'}, FiscCalQuarter={'$(vCurrentQtr)'} >} ReportedPrice) / Sum({$<FiscCalYr={'$(PreviousYear)'}, FiscCalQuarter={'$(vCurrentQtr)'} >} ReportedPrice)) -1,grpCGeoPartnerProduct)),
If(vComparePeriod = 'Month',
max(total aggr((Sum({$<FiscCalYr={'$(CurrentYear)'}, FiscCalMonth={'$(vCurrentMonth)'} >} ReportedPrice) / Sum({$<FiscCalYr={'$(PreviousYear)'}, FiscCalMonth={'$(vCurrentMonth)'} >} ReportedPrice)) -1, grpCGeoPartnerProduct)),
If(vComparePeriod = 'Week',
max(total aggr((Sum({$<FiscCalYr={'$(CurrentYear)'}, FiscCalWk={'$(vCurrentWeek)'} >} ReportedPrice) / Sum({$<FiscCalYr={'$(PreviousYear)'}, FiscCalWk={'$(vCurrentWeek)'} >} ReportedPrice)) -1, grpCGeoPartnerProduct))
)
)
)
)
How do I test for the lowest value instead of the highest value? I tried replacing "max" with "min" but it didn't work.
I should mention that I tried hard-coding a fixed value & that still did not work. Any ideas what is causing this problem?