invalid price value

Avatar

Avatar

mmbb110

Avatar

mmbb110

mmbb110

14-11-2020

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

 

Accepted Solutions (1)

Accepted Solutions (1)

Avatar

Avatar

anasso83525035

Avatar

anasso83525035

anasso83525035

15-11-2020

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.

Answers (1)

Answers (1)

Avatar

Avatar

anasso83525035

Avatar

anasso83525035

anasso83525035

14-11-2020

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.