Let me try to explain my problem:
I have a field on the account object indicating whether or not a pgm is complete (0 or 1), and a field on a related object indicating whether or not this is a target account (0 or 1). An account may or may not have the related object indicating if it is a target account. I need to calculate, in a report, the % of accounts where program is complete where the denominator is # targeted accounts + accounts not targeted but pgm completed.
Solutions attempted:
1) Report type with related object - missing accounts w/o related object.
2) Analytic snapshots - limit 2000 records. We have more.
3) Report type with or without related object - tried using formula fields, but can't get what I need without using a formula field in another formula, or being able to filter based on a formula field
This is complex & difficult to explain, but does anyone understand what I'm trying to do and know a way I can get my % complete?
7 respuestas
