I have problem with calculated fields.

Value is being properly calculated and it's working properly until I'm saving the record.

When you are editing it or displaying record after has been save fields are displaying only "0.00".

I have problem with calculated fields.

Value is being properly calculated and it's working properly until I'm saving the record.

When you are editing it or displaying record after has been save fields are displaying only "0.00".

My formula is quite complex and I have checked that when it's easier/shorter it works but I need exactly formula that I'm using.

Please see example below:

**ifElse(greaterThan(32,subtract(subtract(daysUntil(date("2016-08-31")),-1),daysUntil($date_closed))),ifElse(greaterThan(subtract(subtract(daysUntil(date("2016-08-31")),-1),daysUntil($date_closed)),0),multiply(subtract(subtract(daysUntil(date("2016-08-31")),-1),daysUntil($date_closed)),divide($amount,366)),0),multiply(31,divide($amount,366)))**Based on your formula I presume this is for the Opportunities module, and from what I can tell by looking at your formula essentially your logic is performing the following:

- Check to see if the Opportunities Expected Close Date is within 32 days of 31/08/2016
- If it is then check that the Expected Close Date is not past 31/08/2016
- If the Expected Close Date is not past 31/08/2016 then take the number of days between these two dates and multiply it by the Amount / 366 (essentially what the Opportunity is worth on a daily basis)
- the Expected Close Date is past 31/08/2016 then use 31 days instead of the difference (essentially working out what you would get for 1 month of this Opportunity)

Do you agree that this is essentially what your formula is calculating? I have written it like this as I am struggling to understand why you would build this formula into Sugar, especially using a fixed date as in a few months you would have to change the formula and mass update all Opportunities. If this is for a one-time only report I would probably generate a Report and export the data to Excel where you can then easily manipulate the data and perform this check with ease.

Sorry that I haven't reply earlier to your comments.

I have received information that it has been identify as defect #76071.

Harold Masselink - there are only two digits after commas

Liam Hastings - calculation that it should be saved is essential for us and for our sales team. Exporting reports to excel sheet is not a work-around. If the Excel could be a solution we could have not buying SugarCRM licences for professional edition. Cause in principal you can keep everything in excel sheets.

Greetings,

Kamil

Kamil,

What kind of formula is it that you are using? We have a known defect with RollUpSum that returns the same behavior that you are describing. I'm not sure if this is what you are running into since this defect is for a different version of Sugar.

Kind Regards,

Lori Arce