Enrichment always rounding to integer | Community
Skip to main content
M
michaelwilding
Level 3
March 20, 2025
Solved

Enrichment always rounding to integer

  • March 20, 2025
  • 1 reply
  • 912 views

We have a formula in enrichment, for example:

 

DaysDiff([cusTable/@Date],GetDate())/7

 

If the result is 24.14, Adobe is always showing 24.00.

 

I've tried using Round and ToDouble, I cannot see any cause for this rounding. Can anybody point me to how to prevent this rounding happening so we can see the result to two decimal places?

Best answer by michaelwilding

It turned out that we needed to wrap ToDouble around it twice.

1 reply

Craig_Thonis
Adobe Employee
Craig_ThonisAdobe Employee
Adobe Employee
March 20, 2025

Hi Michael, the DaysDiff looks right so it may be a schema or data issue that would require review from Campaign Support unless someone else recognizes the problem.

 

Regards,

Craig

    M
    michaelwildingAuthor
    Level 3
    March 20, 2025

    Thanks Craig. I am currently just looking at the results on the interim results on the transitions. As it's not being saved into a field could a schema issue still cause this?

     

    I've also tested without the division by 7. This produces the correct number, which is of course an integer. 

    Terms & ConditionsAccessibility statement

    Loading footer...