Have been scouring the community and documentation all afternoon to no avail, wondering if someone could help me out?
I'm trying to build a formula to work out a cumulative saving on a Case (custom field "saving_pcm_c") up to a limit of 6 months.
i.e. The workload of a Case has an associated cost saving and we continue to report that cumulative saving for 6 months, at which point it is fixed in time.
Ultimately I will use this to work out an ROI of the piece of work based on the one-off cost of doing the work (another custom field).
I used to be a lot better at these kind of things but have not been a SF admin for some time, I am stuck at the first hurdle of the case closed date being date-time, so I can't use with the MONTH function!!
Sad face.
Any help anyone could offer would be greatfully received likely with beer (you know who you are!).
1 Antwort
