Feb 18, 2005 #1 maddur31 ISP Joined Feb 18, 2005 Messages 7 Location 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 Joined Jan 25, 2005 Messages 102 what output does this formula generate? John Borges Upvote 0 Downvote
Feb 19, 2005 #3 dgillz Instructor Joined Mar 2, 2001 Messages 10,059 Location 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 Joined Sep 5, 2002 Messages 7,628 Location 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 Joined Feb 18, 2005 Messages 7 Location 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 Joined Sep 5, 2002 Messages 7,628 Location 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)