Set analysis Excluding calculated value greater than X

[#1]

Hi, I have created monthly bar graph that executes a per unit equation (shown below).  I need the graph to exclude any out of range values for the outcome of the equation, such as if the per unit cost is >$10, then that month's per unit cost would be excluded from the graph. As you can see, there is already one set analysis in this equation...

=Sum ( {<CalendarField =>} [Total]) / Sum ( {CalendarField =>} [Volume])

To put it simply, what I need to show is if (total/volume)> 10, exclude from the graph.

Please help.

[MayilVahanan · Accepted solution]

HI,

     You can use like this,

         If(Sum ( {<CalendarField =>} [Total]) / Sum ( {CalendarField =>} [Volume]) > 0,

                    Sum ( {<CalendarField =>} [Total]) / Sum ( {CalendarField =>} [Volume]))

     or

  If(Sum ( [Total]) / Sum ([Volume]) > 0, 

                    Sum ( {<CalendarField =>} [Total]) / Sum ( {CalendarField =>} [Volume]))

Hope it helps

[#3]

Thank you! The first expression worked.