Feb 18, 2005 #1 maddur31 ISP Feb 18, 2005 7 US how can I COUNT THE STRING IN THE FORMULA. When I count the string field getteing error. the formulafield cannot be summarized.
how can I COUNT THE STRING IN THE FORMULA. When I count the string field getteing error. the formulafield cannot be summarized.
Feb 18, 2005 #2 jbpez Programmer Jan 25, 2005 102 what output does this formula generate? John Borges Upvote 0 Downvote
Feb 19, 2005 #3 dgillz Instructor Mar 2, 2001 10,041 US Please post the entire formula to the forum. Software Sales, Training, Implementation and Support for Exact Macola, eSynergy, and Crystal Reports http://www.srhconsulting.com Upvote 0 Downvote
Please post the entire formula to the forum. Software Sales, Training, Implementation and Support for Exact Macola, eSynergy, and Crystal Reports http://www.srhconsulting.com
Feb 21, 2005 #4 Madawc Programmer Sep 5, 2002 7,628 GB What are you trying to count? If you generate the string using a rule, then try a running total that applies the same rule. Things 'can't be sunmarised' if you are asking Crystal to assess something that doesn't arrise directly from the data. Madawc Williams (East Anglia, UK) Upvote 0 Downvote
What are you trying to count? If you generate the string using a rule, then try a running total that applies the same rule. Things 'can't be sunmarised' if you are asking Crystal to assess something that doesn't arrise directly from the data. Madawc Williams (East Anglia, UK)
Feb 21, 2005 Thread starter #5 maddur31 ISP Feb 18, 2005 7 US hoe can I display in graph if the value is null I want to display as 0. Thanks Maddur Upvote 0 Downvote
Feb 22, 2005 #6 Madawc Programmer Sep 5, 2002 7,628 GB Do it via a formula field: Code: if isnull({your.amount}) then 0 else {your.amount} Madawc Williams (East Anglia, UK) Upvote 0 Downvote
Do it via a formula field: Code: if isnull({your.amount}) then 0 else {your.amount} Madawc Williams (East Anglia, UK)