round the percent

[rvnth]

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.

[CampaignerForLife]

Try using this expresion in the expr field

Round(<number>, <number of decimals>)

Source:
https://experienceleague.adobe.com/en/docs/campaign-standard/using/managing-processes-and-data/filte...

[LakshmiPravallika]

hHi @rvnth ,

Please try this way and let me know if it works

Round((Percent([indicators/@estimatedRecipientOpen],[indicators/@successWithoutSeeds]))*100, 2)

Regards,

Pravallika.

[rvnth]

Hi @LakshmiPravallika ,

Thank you. It worked, but for one delivery, the decimal is still not rounding off to two decimal places. Please advise.

[Sukrity_Wadhwa]

Hi @LakshmiPravallika,

Could you please help @rvnth further here?

Thanks!

[rvnth · Accepted solution]

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

[Sukrity_Wadhwa]

Thanks @rvnth for sharing your solution.