Roll-Up field Decimals

(0) Share

Report

Posted on by Community Member Microsoft Employee

Dear Community,

I have created custom Roll-up field to total up the Revenue. How ever i have issues with decimals as if value is for example 250.00 Field is totaling up as 250.09

Precision is set as 2 for the field, Please see the below screen shot, Total KIT Cost Price should be 250.00 not 250.09

Any idea?

Please help!

*This post is locked for comments

All responses (3)

Answers (0)

Suggested answer

TheMarkChristie 10,328 on at

Like (0)

Report

RE: Roll-Up field Decimals

As long as all the fields underneath are the same precision then there should be no issue, Can you take a screencap of the roll up query?
Community Member Microsoft Employee on at

Like (0)

Report

RE: Roll-Up field Decimals

Hi Mark,

Thank You

just one currency field to get the total amount. is there any other way i can get the total of one field?

This field is total field to total up cost price of each product attached to opportunity. Total field is in Opportunity entity and rolling up from Opportunity product entity.

Thanks

Satheesh
Suggested answer

TheMarkChristie 10,328 on at

Like (0)

Report

RE: Roll-Up field Decimals

Hi Satheesh

Are all off the fields that you are rolling up currency fields as well?