Enrichment always rounding to integer

Question

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?

michaelwilding · Accepted Answer

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

Craig_Thonis · Answer

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

Sign up

Login with SSO

Login to the community

Login with SSO