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
Bedrock Mission!

Learn more

View all

Sign in to view all badges

SOLVED

invalid price value

mmbb110
Level 8
Level 8

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

 

1 Accepted Solution
anasso83525035
Correct answer by
Level 3
Level 3

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.

View solution in original post

14 Replies
mmbb110
Level 8
Level 8
Sorry to bump this up, if anyone has any recommendations for me would be great.
anasso83525035
Level 3
Level 3

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.

 

 

mmbb110
Level 8
Level 8

@anasso83525035, can you please provide some more guidance on this. my workflow looks like below at present.

 

Workflow.JPG

 

I have the following in the target, currently I am just using my profile.

 

image1.JPG

anasso83525035
Correct answer by
Level 3
Level 3

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.

View solution in original post

mmbb110
Level 8
Level 8

Thanks for your response, I tried exact steps and it still shows invalid price. image is attached.

 

price.JPG

anasso83525035
Level 3
Level 3
Update the expression and replace again in the email : Round(ToDouble(@cusMembershipRnwlPrice), 2)
mmbb110
Level 8
Level 8
@ anasso83525035, I tried the newest solution provided and now it's not even passing the price value in the html, I just get $0. Y workflow run fine and I checked the data structure in my query and it is pulling the correct audience with price value, i used the same personalisation in code and tested preview via profile substitution but it gives $0 only.
shelly-goel
Community Advisor
Community Advisor
@mmbb110 can you please share the screengrab of the values you see in the transition past your query? Ideally the float value that you gave in the profile gives the correct value though some formatting is happening in the email designer
mmbb110
Level 8
Level 8

@shelly-goel, Yes, in the transition I do see the correct value, like 7.99, I have attached an image for reference.

 

transition.JPG

anasso83525035
Level 3
Level 3
I tested the new expression and sent an email and it's working. Please delete and replace the personalisation field to take into acount the changed formula. Also query your profile and send yourself and email to check final result, I don't think you can see the result in profile substitution preview since it's an additional data coming from the workflow.
mmbb110
Level 8
Level 8
Correct Answer Update the expression and replace again in the email : Round(ToDouble(@cusMembershipRnwlPrice), 2)