Data Grouping Error

[manouchehr19346]

Hi everyone,

I have a dataflow which have copied from one account into another one, and now I am trying to create tables and reports based on it. I am using the data grouping and when I group the data, I get the error: 

Error in query 'booking_overview_source'. Expression.Error: The number is outside the valid range for currency values. Valid values ​​are in the range between -922337203685477.5808 and 922337203685477.5807.
Details:
[Function]

The values that I use in grouping function are not big values, and they are way smaller than the limit, but I get this erro. I have copied the tables from other account, and they are working well before grouping, but when I use the group function I get the error.

I would apppreciate if someone could help me with this isse.

Best Regards,

Manouchehr

[Anonymous]

Hi @manouchehr19346 ,

This is strange, and perhaps you can troubleshoot the problem in two ways:
1. Make sure the data types of the columns on which the grouping is based are consistent. Sometimes, mismatched data types can cause errors
2. check for any null or missing values in the columns used for grouping.

Hope it helps!

Best regards,
Community Support Team_ Scott Chang

If this post helps then please consider Accept it as the solution to help the other members find it more quickly.