Apex Code Development You need to sign in to do that
Don't have an account?
Killian How to calculate the numerical difference fields in different records?
We have a custom numerical field in the Contract tab. This field is used to "track" a numerical change from one Contract to the next. I want to report on the difference between this custom field between two Contracts. (in other words, compare this custom field from one record to another, and calculate the difference). Does anyone know how do I do this?
- Do I create a calculated Formula field? I tried but I don't think this works because Formula fields only seem to work in the same Contract/Record.
- Do I create a calculated field in a Report? I can't see how I do this.
- Do I need to build something in s-control??? I would not where to start.
Anyone have any idea about this? Am I going about this all wrong???
Any help at all is appreciated.
Killian
Formula field wouldn't work since they don't have the permission to go from one object to another. You may be able to build something like this as an scontrol but it would require a lot more information before it could be theorized with any reliability. Information such as what records would need to be compared to other records? Should it only compare two records or should there be a mean or median value returned for more? If you would like to go over it then send me an email.