Values Changes in formula

sasidharp
sasidharp Registered Posts: 27 ✭✭✭✭
in Using Dataiku

I have values which exceed the decimal points and this the vaues are not calculated accuately in formula.

what changes should be done in order to get correct value:

formu.PNG

 what kind of approach is suitable in this situation?

· Share on FacebookShare on Twitter

Answers

  • ATsao
    ATsao Dataiker Alumni, Registered Posts: 139 ✭✭✭✭✭✭✭✭

    Hi sasidharp,

    Unfortunately, I am unable to reproduce the issue when testing this locally. Please see the attached screenshot. In my case, using the same values from your screenshot, the formula succeeds.

    Can you confirm that all columns that are being used in this formula with numval() contains numerical values? If you simplify this formula and start with just one column, and slowly add each "part" or column one by one, can you confirm that it's this particular "hexane_flow_46fc218" column that's causing the formula to fail? Additionally, what version of DSS are you using?

    If possible, would you also be able to share some sample data that exhibits this issue?

    Thanks,

    Andrew

    · Share on FacebookShare on Twitter
Bookmark this topic

Categories

Setup Info
    Tags
      Help me…