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
  • 921 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
    michaelwildingAuthorAccepted solution
    Level 3
    March 28, 2025

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

      Terms & ConditionsAccessibility statement

      Loading footer...