Round Down In Beast Mode

kivlind
kivlind 🟡
in Data Platform & Data Science

How do I round down to the nearest thousands. For example, 17,692 should be 17,000...not rounded up.

Best Answer

  • Valiant
    Valiant 🔵
    Answer ✓

    A believe a Beast Mode function like this should work:

     

    FLOOR(`value` / 1000) * 1000

    That will revert 17692 to 17.692. Floor function rounds decimals down to nearest integer and then multiply back by 1000 to get 17,000.

     

    Hope that helps,

    Valiant

Categories