Validation Error for Negative Values in Power Query

[dataworld1]

Hi, 

I have the following error message below when trying to refresh my Data Table in Power Apps. 

I have a custom variance column that outputs negative values.

How do i get the query to accept the negative values? 

I have tried to use the rounding function this was unsuccessful 

Note the column is a custom column that calculates two values together. 

Thank you

[Syk · Accepted solution]

Here's a similar thread with a solution. Looks like you need to change the data type in Power Apps.

https://community.fabric.microsoft.com/t5/Power-Query/Dataflow-in-a-Power-Apps-Environment-refresh-e...