Log in to create and rate content, and to follow, bookmark, and share content with other members. Not a member? Join Now!

Why does Prize Amount not display the way I want it to?

Discussion created by fmpro_novice on Jan 23, 2018
Latest reply on Jan 23, 2018 by philmodjunk

Like • Show 0 Likes0
Comment • 5

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!

Outcomes

5 Replies

philmodjunk Jan 23, 2018 11:02 AM
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.
Like • Show 0 Likes0
Actions
fmpro_novice @ philmodjunk on Jan 23, 2018 12:14 PM
I'm such an idiot! No wonder everyone was so perplexed. The beginning value was $37.50. The ending value is 37.5.
Sorry about that.
Like • Show 0 Likes0
Actions
philmodjunk @ fmpro_novice on Jan 23, 2018 12:27 PM
37.5 is the value of the field. $37.50 is the same value with typical currency formatting applied. You can do that for a number field but not the text result of your calculation.

You could add adfitional text manipulation to your calculation or you might use merge fields on your layout:
<<calculation field with Case here>> <<TeamSponser>> <<PrizeAmount>> <<UniquePlayerTeamDesignation>> Additional Line If text

You can then select this entire block of layout text (you need selection handles, NOT highlighted text) and select a currency format.
Like • Show 0 Likes0
Actions
fmpro_novice Jan 23, 2018 3:16 PM
I figured out why it was working in one place but not in another. You are correct, even though the Prize Amount is set to display currency, in reality, it is still just showing a plain number. What do you think would be the best approach to just loop through the Prize Amounts and if a dollar sign is not part of the real number, add one. Then, if $37.50 is displaying as $37.5 - add a zero behind the 5?
Like • Show 0 Likes0
Actions
philmodjunk Jan 23, 2018 3:24 PM
I have already suggested a different way to get what you have requested.
Like • Show 0 Likes0
Actions

Why does Prize Amount not display the way I want it to?

Outcomes

Related Content

Recommended Content