invalid price value | Community
Skip to main content
Level 9
Nov 14, 2020 11:57 AM UTC
Solved

invalid price value

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,

 

 

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,

 

 

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

 

 

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
anasso83525035Accepted solution
Level 3
Nov 15, 2020 3:42 PM UTC

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

 

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

 

Hope this is clear enough.

14 replies

anasso83525035Accepted solution
Level 3
Nov 15, 2020 3:42 PM UTC

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

 

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

 

Hope this is clear enough.

Translate
mmbb110Author
Level 9
Nov 15, 2020 4:07 PM UTC

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

 

Translate
Level 3
Nov 15, 2020 4:25 AM UTC

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.

 

 

Translate
mmbb110Author
Level 9
Nov 15, 2020 8:27 AM UTC

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

 

 

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

 

Translate
mmbb110Author
Level 9
Nov 15, 2020 2:59 AM UTC
Sorry to bump this up, if anyone has any recommendations for me would be great.
Translate