Expand my Community achievements bar.

SOLVED

invalid price value

Avatar

Level 9

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

Avatar

Correct answer by
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

Avatar

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

Avatar

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.

 

 

Avatar

Level 9

@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

Avatar

Correct answer by
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.

Avatar

Level 9

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

 

price.JPG

Avatar

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

Avatar

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

Avatar

Employee 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

Avatar

Level 9

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

 

transition.JPG

Avatar

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.

Avatar

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

Avatar

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