cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
JasonG-BI Regular Visitor
Regular Visitor

Rounding down to the nearest 0.5

Hi,

 

I am trying to implement a formulae that rounds down to the nearest 0.5. i.e 20.33 would be 20.00. 25.75 would be 25.5........

 

Any help with a formulae would be much appreciated. I've tried INT but to no success as yet.

1 ACCEPTED SOLUTION

Accepted Solutions
JasonG-BI Regular Visitor
Regular Visitor

Re: Rounding down to the nearest 0.5

Think I've solved my own question with Floor(Column,0.5) using a measure

1 REPLY 1
JasonG-BI Regular Visitor
Regular Visitor

Re: Rounding down to the nearest 0.5

Think I've solved my own question with Floor(Column,0.5) using a measure