Hi team,
Is there a way to round the decimal points for the function below:
(percent([indicators/@estimatedRecipientOpen],[indicators/@successWithoutSeeds]))*100
I tried adding round:
round((percent([indicators/@estimatedRecipientOpen],[indicators/@successWithoutSeeds]))*100, 2)
but it throws an error saying that the round function requires 2 or 3 arguments. Please suggest how I can achieve this.
<node expr="(percent([indicators/@estimatedRecipientOpen],[indicators/@successWithoutSeeds]))*100" alias="@OpenRate"/>
Thank you in advance.
Solved! Go to Solution.
Views
Replies
Total Likes
Hi @Sukrity_Wadhwa ,
I was able to sort this out by using the below expression:
<node expr="ToInteger((Percent([indicators/@estimatedRecipientOpen],[indicators/@successWithoutSeeds]))*1000)/10" alias="@OpenRate"/>
<node expr="ToInteger((Percent([indicators/@recipientClick], [indicators/@estimatedRecipientOpen]))*1000)/10" alias="@ClickRate"/>
Thank you
Try using this expresion in the expr field
Round(<number>, <number of decimals>)
Views
Replies
Total Likes
hHi @rvnth ,
Please try this way and let me know if it works
Round((Percent([indicators/@estimatedRecipientOpen],[indicators/@successWithoutSeeds]))*100, 2)
Regards,
Pravallika.
Hi @LakshmiPravallika ,
Thank you. It worked, but for one delivery, the decimal is still not rounding off to two decimal places. Please advise.
Views
Replies
Total Likes
Views
Replies
Total Likes
Hi @Sukrity_Wadhwa ,
I was able to sort this out by using the below expression:
<node expr="ToInteger((Percent([indicators/@estimatedRecipientOpen],[indicators/@successWithoutSeeds]))*1000)/10" alias="@OpenRate"/>
<node expr="ToInteger((Percent([indicators/@recipientClick], [indicators/@estimatedRecipientOpen]))*1000)/10" alias="@ClickRate"/>
Thank you
Thanks @rvnth for sharing your solution.
Views
Replies
Total Likes
Views
Likes
Replies
Views
Likes
Replies