Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
BedrockMission!

Learn More

View all

Sign in to view all badges

invalid price value

Avatar

Avatar
Applaud 25
Level 3
mmbb110
Level 3

Likes

17 likes

Total Posts

261 posts

Correct Reply

17 solutions
Top badges earned
Applaud 25
Validate 10
Validate 1
Contributor
Shape 1
View profile

Avatar
Applaud 25
Level 3
mmbb110
Level 3

Likes

17 likes

Total Posts

261 posts

Correct Reply

17 solutions
Top badges earned
Applaud 25
Validate 10
Validate 1
Contributor
Shape 1
View profile
mmbb110
Level 3

14-11-2020

Hi Community,

 

I am not able to figure out an issue with one of our re-occurring emails which is displaying incorrect price value within the content.

 

example: it should be 7.99 and it shows as below,

 

renewal_price.JPG

 

The value is coming from Profile resource and the data type used for it is floating number.

in the workflow the expression used is as below,

 

expression.JPG

 

should I use a different data type?the values defined for the profiles are also having 7.99

 

profile.JPG

 

Accepted Solutions (1)

Accepted Solutions (1)

Avatar

Avatar
Validate 1
Level 2
anasso83525035
Level 2

Likes

6 likes

Total Posts

30 posts

Correct Reply

6 solutions
Top badges earned
Validate 1
Give Back 3
Give Back
Boost 5
Boost 3
View profile

Avatar
Validate 1
Level 2
anasso83525035
Level 2

Likes

6 likes

Total Posts

30 posts

Correct Reply

6 solutions
Top badges earned
Validate 1
Give Back 3
Give Back
Boost 5
Boost 3
View profile
anasso83525035
Level 2

15-11-2020

In the additional data tab of your query add the expression as follows :

 

anasso83525035_0-1605454352090.png

Then open your email delivery and replace the personalization field with the @roundedRnwlPrice in additional data :

 

anasso83525035_1-1605454952743.png

Hope this is clear enough.

Answers (1)

Answers (1)

Avatar

Avatar
Validate 1
Level 2
anasso83525035
Level 2

Likes

6 likes

Total Posts

30 posts

Correct Reply

6 solutions
Top badges earned
Validate 1
Give Back 3
Give Back
Boost 5
Boost 3
View profile

Avatar
Validate 1
Level 2
anasso83525035
Level 2

Likes

6 likes

Total Posts

30 posts

Correct Reply

6 solutions
Top badges earned
Validate 1
Give Back 3
Give Back
Boost 5
Boost 3
View profile
anasso83525035
Level 2

14-11-2020

Hello @mmbb110 

 

You can add an enrichement in your workflow and use the Round function to limit the price to two decimals : 

Round(@cusMembershipRnwlPrice, 2).

 

You will then have to replace the Personalization field in your email with the new defined one.

 

Cheers.