Round down

[hnorgaar]

Hi

How can I round down to nearest 100 i a query?
Thx for any input

 

[etaf]

how about
=FLOOR(A2, 100)

 

[hnorgaar]

how about
=FLOOR(A2, 100)

I will like to do it in a query if possible

 

[RoryA]

You can use Number.RoundDown and specify -2 as the number of digits.

 

[etaf]

sorry missed the forum you are in - my bad
perhaps RoryA will delete my posts

 

[hnorgaar]

You can use Number.RoundDown and specify -2 as the number of digits.

Tried that but 11478.75 gives me 11.500, should be 11.400

 

[RoryA]

It sounds like you used Number.Round not Number.RoundDown

 

[hnorgaar]

It sounds like you used Number.Round not Number.RoundDown

#"Rounded Down1" = Table.TransformColumns(#"Rounded Down",{{"Price out (excl VAT, your currency)", Number.RoundDown,-2, Int64.Type}})

Does that looks correct? Doesnt work

 

[RoryA]

No, if you are trying to do it in-place, it would be:

#"Rounded Down1" = Table.TransformColumns(#"Rounded Down",{{"Price out (excl VAT, your currency)", each Number.RoundDown(_, -2), Int64.Type}})

 

[hnorgaar]

No, if you are trying to do it in-place, it would be:

#"Rounded Down1" = Table.TransformColumns(#"Rounded Down",{{"Price out (excl VAT, your currency)", each Number.RoundDown(_, -2), Int64.Type}})

Great, thx a lot