Enrichment always rounding to integer

[michaelwilding]

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?

[Craig_Thonis]

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

[michaelwilding]

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. 

[michaelwilding]

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