Hello @Kobi Averbuch ,
Thanks for the question and using MS Q&A platform.
I checked your expression - I checking the output at the level
iif(toInteger($$)<0, power(2, 32),toDouble(0))+toDouble($$)
I was getting the number in the in the scientific format.
From research, currently
toInteger cannot handle scientific format of numbers.
I did modify the expression and i got a simlar output at my end.
So I came up with the below expression that gives the required output
toDecimal(iif(toInteger(-20)<0, toDecimal(power(2, 32),12),toDecimal(0))+toDecimal(-20),12,0)
I have used -20 for illustration but you can replace it at your end.
Integer Range is between : -2147483648 to 2147483647.
Unsigned integer range would be between 0 to 4294967295
You may not be able to use the
Hope this will help. Please let us know if any further queries.
- Please don't forget to click on or upvote button whenever the information provided helps you. Original posters help the community find answers faster by identifying the correct answer. Here is how
- Want a reminder to come back and check responses? Here is how to subscribe to a notification
- If you are interested in joining the VM program and help shape the future of Q&A: Here is how you can be part of Q&A Volunteer Moderators