invalid price value

[mmbb110]

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

[mmbb110]

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

[anasso83525035]

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]

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

[anasso83525035]

[double post to delete]

[anasso83525035 · Accepted solution]

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.

[mmbb110]

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

[anasso83525035]

Update the expression and replace again in the email : Round(ToDouble(@cusMembershipRnwlPrice), 2)

[mmbb110]

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

[mmbb110]

Anything I am still missing?

[shelly-goel]

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

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

[anasso83525035]

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]

@anasso83525035 it works perfect via sending the actual email. Thank you.

[mmbb110]

Correct Answer Update the expression and replace again in the email : Round(ToDouble(@cusMembershipRnwlPrice), 2)