Following is a text calculation:
Case ( Length ( PlayerTeamOverride ) ; PlayerTeamOverride ; Substitute ( List ( TEAMPLAYER::cPlayerName ) ; ¶ ; ", " ) ) & " " & TeamSponsor & " " & Prize Amount & " " & Unique Player Team Designation & " " & Additional Line of Text To Add To Player Team
The field Prize Amount is a number. On the layout it is set to currency and on the layout when the field is by itself, it shows, for example, $37.25
But, when it is a part of the above calculation, it displays as 37.5. Can someone get me started in the right direction in figuring out why this is happening?
Thank you!
Are you that it’s 37.5? Isn’t it 37.25?
formatting differences and the fact that this calculation produced a text result will keep your currency format from happening, but it doesn’t explain the difference in value.