Formula to suppress

[Pete271]

I'm on CR8.5 and trying to write a report which needs a formula to suppress certain data.

A section of the report has 3 columns

Gift Amount Ask Amount Potential

the first 2 columns are numeric with Potential being a text table.

What I would like is if for a value to appear in only one column per row.

So, if there is a Gift Amount greater than £0.00 I want Ask Amount and Potential to be suppressed, and so on for the other two combinations.

I'm tieing myself in knots trying to write a formula that will work properly.

Any advice will be gladly received.

Pete

 

[synapsevampire]

Please read your posts before saubmitting them.

"the first 2 columns are numeric with Potential being a text table."

Post that again, as columns don't become text tables.

Try placing this in the suppression formula for each field:

if not(isnull({table.Ask Amount}))
and
{table.Ask Amount} <> 0 then
0

-k

 

[lbass]

I think you need to show some sample data as it currently displays in the detail section, and then show a sample of how you would like it to display.

-LB

 

[synapsevampire]

sorry, should have been:

if not(isnull({table.Ask Amount}))
and
{table.Ask Amount} <> 0

-k

 

[Pete271]

Apologies for the lack of clarity, it was all so clear in my head!

Take Two:

Gift Amount(Numeric Value)
Ask Amount (Numberic Value)
Potential (Text Value)

What is happening currently

Gift Amount Ask Amount Potential
£5,000 Up to £5,000
£10,000 £15,000 £10,000 - £25,000


What I want to happen is for each row to only have one value. For Example:


Gift Amount Ask Amount Potential
£5,000
£10,000

Is it possible?

 

[dgillz]

Under what circumstances would potential show the value?

I think you need to show us more sample data .

Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports

http://www.gainfocus.biz

"If you have a big enough dictionary, just about everything is a word"
--Dave Barry

 

[Pete271]

Potential would display a value only if 'Gift Amount' and 'Ask Amount' equal £0.00

 

[dgillz]

Pete,

And what would the value of potential be if the other two are zero?

Also can I assume that the british pound symbol is just a formatting issue and is not actually stored in the database as part of a text field?

Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports

http://www.gainfocus.biz

"If you have a big enough dictionary, just about everything is a word"
--Dave Barry

 

[Pete271]

yes, the pound sign is just formatting.

Potential could have any of the following

Up to £5,000
£5,001 - £10,000
£10,001 - £25,000
£25,001 - £50,000

and so on. Is that enough information to work with?

 

[lbass]

You are only showing one possible scenario, and I'm guessing there are more. But you could place the gift amount in the detail section, and add a formula for the ask amount:

if isnull({table.giftamt}) then
{table.askamt}

Use another formula for potential:

if
(
isnull({table.giftamt}) and
isnull({table.askamt})
) or
{table.giftamt} + {table.askamt} = 0 then
{table.potential}

-LB