How to separate the cents from an amount and put it in another field - SSRS

Suhail

Hi All,

Sorry this question for reporting issue but maybe the solution in NAV, so my question is i have an amount such as 180.60 USD i want separate the 0.60 to another filed and 180 in another filed also for reporting purpose in SSRS.

Do you have any idea how we can do it in NAV development as coding or in SSRS ?

AK

cents := amount mod 1;
dollars := amount - cents;

AK

cents := amount mod 1;
dollars := amount - cents;