Forum Discussion

Kerk's avatar
Kerk
Frequent Visitor
4 years ago
Solved

GENERATESERIES using 0.01 increments

Hello everyone,

 

I am creating a table, which I will use to reference duration down to milliseconds.

For this reason I am using 

 

Time = GENERATESERIES(0.01,1800,0.01)

 

Eveything seems ok until it gets to number 0.81, following that numbers start getting ugly and I see no reason for this happening:

 

 

 

Am I missing something or looks like a bug?

Any ideas?

Thanks 

Need Help
Show and Tell
  • rohit_singh's avatar
    rohit_singh
    4 years ago

    Hi Kerk 

    Please change the number of decimal places from "Auto" to 2.

    Kind regards,

    Rohit


    Please mark this answer as the solution if it resolves your issue.
    Appreciate your kudos! ğŸ˜Š

3 Replies

  • NickolajJessen's avatar
    NickolajJessen
    Solution Sage
    4 years ago

    Lol, that's weird.
    This work?

    GenerateSeries = GENERATESERIES(0.01,1800,round(0.01,2))

    Or
    format column with only 2 decimals?

     

  • rohit_singh's avatar
    rohit_singh
    Solution Sage
    4 years ago

    Hi Kerk 

    Please change the number of decimal places from "Auto" to 2.

    Kind regards,

    Rohit


    Please mark this answer as the solution if it resolves your issue.
    Appreciate your kudos! ğŸ˜Š

    • Kerk's avatar
      Kerk
      Frequent Visitor
      4 years ago

      Thank you for getting back to me. Rounding workaround does the job, however I am concerned somethings is wrong with my installation.