currency calculation

[grahamsc...@gmail.com]

I have a currency field and want to calculate by the amout of travelers to get a total but when it calculates it gives a whole number and forgets the decimal points

eg

#{domestic return cost p_p}*#{total travelers}

438.32*2  = 876.64 but the field returns 876 and forgets the .64

[grahamsc...@gmail.com]

I got this working now I just redid my fields and it all started to show correctly for some reason

[Craig Hunter]

Does your calculation field have Integer result? Change to Real result.

Is the Scale too small? Change from 0 to 2 (for example).

[grahamsc...@gmail.com]

Hi Craig, I had it set to real result but after redoing it again I changed the scale and it worked