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".
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.
I'm using ifElse(and inside several times greaterThan,substract,multiply), there is no RollUpSum function.
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:
Hi Kamil Garmulewicz,
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:
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.
Sugar hardcodes 6 decimals when calculating values (not sure what Sugar version). This might lead to values that are not allowed (the fieldtype is int?) because of the decimals. Use the floor() function to drop the decimals.
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.
Retrieving data ...