Sum decimal values

[grads]

Hi,

I'm having a report problem that I can't quite get to work correctly. I have a list of numbers something like 2326.500 and 5632.211. What I'm trying to do is sum only the decimal portion. I only want .711 to show within a field. What I'm trying to do is use val(right(transform(ex_ent),3)) but there is a problem if one of the decimals has a zero in it. It gives me 8.70. Any help would be much appreciated.

 

[DSummZZZ]

Use the MOD() and INT() functions:

nResult = MOD( 2326.500, INT(2326.500 )) + ;
MOD( 5632.211, INT(5632.211))

Of course, the numbers can be subsituted with variables.

Dave S.

 

[grads]

I'm sorry but I forgot to mention that I'm doing these totals in a group footer and it's difficult to separate the values.

 

[DSummZZZ]

That's why I said variables could be used.

MOD(ex_ent, INT(ex_ent)) will return the decimal portion of whatever you use for ex_ent. You can use this as an expression wherever you need it.

Dave S.

 

[grads]

DSummZZZ you rule! I am such an idiot. That worked perfectly. Thank you so much for taking the time to help me. I appreciate it so much.

 

[DSummZZZ]

Thanx. Glad you got it working!

Dave S.