September 11, 2015 at 6:02 am
I've found 4 fields which cause the Conversion overflow.
1 example: "TotalRevenueLCY".
The total sum value in SQL: 858376803445.19000000000000000000
Min value: -2243974.89000000000000000000
Max value: 429080429080.00000000000000000000
When I put this field as only measure in the measuregroup, I get the overflow conversion.
September 11, 2015 at 6:06 am
rc 77550 (9/11/2015)
I've found 4 fields which cause the Conversion overflow.1 example: "TotalRevenueLCY".
The total sum value in SQL: 858376803445.19000000000000000000
Min value: -2243974.89000000000000000000
Max value: 429080429080.00000000000000000000
When I put this field as only measure in the measuregroup, I get the overflow conversion.
Those are big numbers, but shouldn't a double be able to handle those?
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
Viewing 2 posts - 16 through 16 (of 16 total)
You must be logged in to reply to this topic. Login to reply