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.

[mmbb110 · 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 · Accepted solution]

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

[anasso83525035 · Accepted solution]

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

[mmbb110 · Accepted solution]

@ 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 · Accepted solution]

Anything I am still missing?

[shelly-goel · Accepted solution]

@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 · Accepted solution]

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

[anasso83525035 · Accepted solution]

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 · Accepted solution]

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

[mmbb110 · Accepted solution]

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