Forum Discussion

android1's avatar
android1
Post Patron
9 years ago
Solved

Show if between 2 values

Hi,

 

I have the following measure Act Hrs % = DIVIDE(SUM(vw_PivotOTIF[Actual Hrs]),SUM(vw_PivotOTIF[Sched Hrs]))

which returns % values of the column [Actual Hrs].

 

I want to show all values >= 80 but less than 100. How would I do this? 

 

Thanks,

 

Gerry

 

 

 

 

Need Help
  • android1's avatar
    android1
    9 years ago

    Hi,

     

    Thanks for the reply. I reworked my other formulas & can do what I need now.

     

    Thanks,

     

    Gerry

2 Replies

    • android1's avatar
      android1
      Post Patron
      9 years ago

      Hi,

       

      Thanks for the reply. I reworked my other formulas & can do what I need now.

       

      Thanks,

       

      Gerry