Round Down In Beast Mode

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

Best Answer

  • Valiant
    Valiant πŸ”΅
    Accepted 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