Sri Arief Wibawa Mukti
Rank: #11468
21Views
5Comments
Can't Calculate Long Integer
Question
Aggregate
Beginner
Data
Database

Hello guys, i have a problem here...

So, i want to calculate Long Integer with Long Integer. My formula is a + b + c, where :

a = 983000000

b = 226133000

c = 1229133000 

im really confused, why the result is -1856701296.

i got all these values from my Entity Attribute with Long Integer Data Type, and already use data conversion function too, is there anybody can help me? thanks a lot.

0
0
on 2020-12-15
Copy link to comment
Shweta Gedam
Rank: #295

Hi Sri Arief Wibawa Mukti,

Hope you are doing well!!

Could you please tell, which Data Conversion function you are using and why?

Thanks


0
0
on 2020-12-15
Copy link to comment
Sachin Waghmare
Rank: #448

Hi Sri,

What is the data type of your variables i.e. a, b, c? Also, please confirm which conversion function you are using to convert the value to long integer?

Please try to use this function.

TextToLongInteger(a) + TextToLongInteger(b) + TextToLongInteger(c)

Thanks & Regards,

Sachin

0
0
on 2020-12-15
Copy link to comment

Hi Sri Arief Wibawa Mukti, 


I assumed your data type is proper as you are taking it from attribute, Can you please post expression snap of calculation. And also button logic flow.


Thanks,

Sanjay

0
0
on 2020-12-16
Copy link to comment
Manish Jawla
Rank: #150

Hi Sri,

Please find the attched oml for reference. The calculation is working fine for me with the long integer.

testcalc.oml

1
0
on 2020-12-16
Copy link to comment
pranav pandey
Rank: #405

Hi Sri Arief Wibawa Mukti,

The calculation seems to be working as expected. I tried the oml provided by Manish Jawla. It will be helpful if you can provide a sample oml with the same logic that you're using.



0
0
on 2020-12-16
Copy link to comment