Forum Discussion

EggyFanClub's avatar
EggyFanClub
New Member
2 years ago
Solved

Unknown Error when trying to edit changes to Datamart

Hi,  I was editing the dataflows, and my datamart fine with no issues when all of a sudden, i get this error that doesn't tell anyone much.  It occurs when trying to save new changes ...
Need Help
  • EggyFanClub's avatar
    EggyFanClub
    2 years ago

    After many hours of tracing back steps I've found what I suspect to be the issue.

    For one calculated column:

    "each if Number.IsNaN([SuccessfulCount] / [TotalShifts] * 100) then 0 else ([SuccessfulCount] / [TotalShifts] * 100), Int64.Type)"

    The issue was NaNs. For whatever reason, they will sneak by all the checks but error when loading in the data. 

    I got around this by converting the column to text type then using the replace tool, then converting back to whole number.

EggyFanClub's avatar
EggyFanClub
New Member
2 years ago

After many hours of tracing back steps I've found what I suspect to be the issue.

For one calculated column:

"each if Number.IsNaN([SuccessfulCount] / [TotalShifts] * 100) then 0 else ([SuccessfulCount] / [TotalShifts] * 100), Int64.Type)"

The issue was NaNs. For whatever reason, they will sneak by all the checks but error when loading in the data. 

I got around this by converting the column to text type then using the replace tool, then converting back to whole number.