ssolberg
VIP Member
So I've been doing World Writers "forever" and just noticed something that has me stunned and stumped. I created a simple calculated field that multiplied qty on hand (LIPQOH) x Unit Cost (COUNCS). The Data Dictionary has the qty field defined as no decimals and our Unit Cost field is 2 decimals. Simple, right? Here is an example of what my calculated field
7 * 29.05 = 203.30
1 * 21.85 = 21.80
Huh? All of the calculations seem to be rounding down? After dinking around with calculations, the only way I could get it to come up with the correct calculation was to first do this:
COUNCS * 100 (into a 0 decimal calc field XYZ so as to strip off the decimal) then,
(LIPQOH * XYZ) * 0.01) to calc the new extended cost into a 2 decimal field.
This can't be right... World Writer can't multiply 2 fields that have different decimal definitions? I must be totally missing something here.
7 * 29.05 = 203.30
1 * 21.85 = 21.80
Huh? All of the calculations seem to be rounding down? After dinking around with calculations, the only way I could get it to come up with the correct calculation was to first do this:
COUNCS * 100 (into a 0 decimal calc field XYZ so as to strip off the decimal) then,
(LIPQOH * XYZ) * 0.01) to calc the new extended cost into a 2 decimal field.
This can't be right... World Writer can't multiply 2 fields that have different decimal definitions? I must be totally missing something here.