Skip to Content
Former Member
Jun 18, 2009 at 04:10 PM

Using Highlighted Expert With Formula (i.e. 'Insert Summary')


I'm trying to compare the summary of a value (via formula (let's call it 'formula A' ) that uses the 'Insert Summary' option in Crystal Reports) with the value that is in a table. The formula does not show in the list of available fields (i.e. in the 'Item editor' section for 'Value of') of 'Highlight Expert'. So, I used 'Other Fields ...' (which took me to 'Choose Field'). I found the field (as a Group#1 total), so I set it up to compare this Group #1 total for 'formula A' to 0.00. I then tried to create logic in formula 'A' which currently does what it supposed to do, but it states that 'A formula cannot refer to itself, either directly or indirectly." How can I refer to the value and flag (i.e. 'crRed' - 'Conditional Formatting Function') the value if they are different. Thanks ! ! !