Help with an expression

[#1]

Hello

I have two expression columns in my report

1. sum[Book Amount]

2. sum([Sale Amount])

I want to write a condition in my first expression where if sum([Sale Amount]) is 0 then make sum([Book Amount]) as 0 so that I can suppress that rows by suppress zero values aand if its not 0 then give me the sale Amount.

Thanks

[Anonymous]

Exactly as you say:

if(sum([Sale Amount])=0, 0, sum([Book Amount]))

[#3]

Exactly as you say:

Sum(If(sum([Sale Amount]) = 0,[Book Amount)]

[anbu1984]

=if(sum([Sale Amount]), sum([Book Amount]))

[mohammadkhatimi]

Hie Rizwan ,

Try this

if(sum([Sale Amount])=0, 0, sum([Book Amount]))

Regards,

Mohammad

[CELAMBARASAN]

Try this

Sum([Book Amount]) * RangeMin(1, Fabs(Sum([Sale Amount])))

[praveenak]

Can i ask for a sample qvw of your requirement? so that i can understand your basic requirement...

Coz I think the request u gave will base on the dependency of Sale Amount and Book Amount in some of my approaches.

If nothing like that dependency present, i suppose it can done with small scripts or QV in-built options.