Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

summarize switch statement ?

I would like to a create switch statement or any other measure that summarizes the "percentage of booked" column in the table below and tells me the number of times an item falls within the range I have specified in the switch statement. Below is an exampl of the ranges i have specified. my desired output would show me 3 items  were less than 70%, 3 items were between 70 and 80 percent and one item was between 80 and 90 percent

 

 

 

Item     Open Orders      Total Booked     Percentage of Booked    
book7810078%
toy4910049%
hat6912058%
cup7911072%
bill199021%
paper688085%
laptop7410074%

 

 

3 Replies

  • Please indicate the expected outcome based on your sample data.

    • Anonymous's avatar
      Anonymous
      Not applicable

      lbendlin 

       

       

      Range   Count   
      < 70%   3
      70% - 80%   3
      80% - 90%   1
      > 90%   0