Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Rounding - If statement

Hi,   I'm wanting to round my data but I want the rounding to be an if statement dependent on the size of the number itself (jobs number). I can do this in Tableau using the formula in the stateme...
Need Help
  • judspud's avatar
    judspud
    6 years ago

    Hi Anonymous 

     

    The round function requires you to give it a number of digits to round to. 

     

    for example;

     

    ROUND(Value,0) would give you the value to the nearest integer.

     

    Hope this helps.

    George

  • JpTall's avatar
    JpTall
    6 years ago

    I often get this error when I have misplaced (or missed out) a bracket, and so it things you haven't given a 'then' or 'else' statement.

    Make sure you haven't missed a bracket after ROUND(SUM())

judspud's avatar
judspud
Solution Supplier
6 years ago

Hi Anonymous 

 

The round function requires you to give it a number of digits to round to. 

 

for example;

 

ROUND(Value,0) would give you the value to the nearest integer.

 

Hope this helps.

George

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi George,

 

Thanks,

It was an error with the way I had written the formula, I think its fixed now! Thanks for your help!