You need to sign in to do that
Don't have an account?
Gail
mod formula issue - different results in report vs page layout (page layout is wrong)
I have a formula (MOD(RollUp_Currency_Field__c, 3)) to determine if something is divisible by 3 (i.e. it will return 0 if divisible by 3). On a record, the amount is 45K. In a report, the formula field correctly returns 0. on the record page, it displays as 3.000. That is just plain wrong so I think this is a bug (especially since the same field is reporting different results on a report vs a page layout). I'm also wondering if it has anything to do with currency conversion (shouldn't as the amount field should store a number only and when I changed the currency of my report, it didn't change the value) or using roll-up fields in the MOD formula?
I have opened a case with Salesforce but we all know how helpful that can be. Has anyone run into this in the past?
I have opened a case with Salesforce but we all know how helpful that can be. Has anyone run into this in the past?
All Answers
Formula fields are calculated when the page is loaded or on the layout or when the Report is RUN - they are not static but Dynamic values.
I believe the currency is getting converted and then looking for MOD function.
Try without converting the currency and see if it shows the same value for layout and report.
Regards,
Ashish