How to remove numbers after the decimal point?

Options
prash_
prash_ Registered Posts: 17

I have an output like 1567.88 and I just want 1567

I tried using the round after round its giving 1568.

Any solution on this?

Answers

  • sj0071992
    sj0071992 Partner, Dataiku DSS Core Designer, Neuron, Dataiku DSS Adv Designer, Registered, Dataiku DSS Developer, Neuron 2022, Neuron 2023 Posts: 131 Neuron
    Options

    Hi,

    Try using function FLOOR()

    This will returns the largest integer value which is less than or equal to the value used as a parameter.

    For example: FLOOR(79.9) will give 79

    Thanks

Setup Info
    Tags
      Help me…