x Want to participate? Join the group to interact

Sage CRM

Welcome to the Sage CRM Support Group on Community Hub! Available 24/7, the forums are a great place to ask and answer product questions, as well as share tips and tricks with Sage peers, partners, and pros.

General Discussion Casting a Currency field to FLOAT or NUMERIC(18,2) returns an integer

State Not Answered
Replies 3 replies
Subscribers 74 subscribers
Views 128 views
Users 0 members are here

Browse Forums

Announcements

105

General Discussion

18k

Casting a Currency field to FLOAT or NUMERIC(18,2) returns an integer

Posted By simonc over 7 years ago

I am casting a Currency field in a view to FLOAT, and the report returns an integer. I have also tried NUMERIC(18,2). Same result.

Any suggestions?

0 simonc over 7 years ago

Same thing if I cast as MONEY
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 simonc over 7 years ago

Any suggestions?
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Sage CRM over 7 years ago

Is the derived field defined in custom_edits?
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Sage CRM

Casting a Currency field to FLOAT or NUMERIC(18,2) returns an integer

COMMUNITY

COMPANY

PARTNERS

SUPPORT & TRAINING