Hi, I am writing a variable to report on customer complaint information in relation to sales expressed as per 100k units
=[Graph LY 1].[MC Complaint Count]/[Query 2 LY].[Line Sales SUs]*100000
however if sales are 0 over a given period I get some extremely high values (as complaints might still be received in that period) that makes graphing the results difficult (a flat line with one very large spike).
Is there any way to limit the output of this variable to a maximum value (say 500 per 100k units) so the graphs are more readable?