Level 9

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.

Best answer by anasso83525035

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.

Level 9

Sorry to bump this up, if anyone has any recommendations for me would be great.

Level 3

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.

Level 9

@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.

anasso83525035Accepted solution

Level 3

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.

Level 9

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

Sign up