Formula drops few records

[Ladyazh]

Please, help me with formula.
Mine is dropping few TOTQTY.
I'd tried and moved () everywhere. Doesn't work.
Please, look at this:
(If({CODE})='PG'then {RATES_VW.EQUIV})*{RATES_VW.TOTQTY}

PG EQUIV TOTQTY
PG 1 1
PG 1 43
PG 1 6

let say Formula would give me 44 instead of 50...

 

[lbass]

You don't need any parens in your formula. It sounds like you might have a null in one of your fields. You might try going to file->report options->convert nulls to default values and see if that helps.

-LB

 

[Ladyazh]

lbass,
I do not have nulls in EQUIV nor TOTQTY columns.
Those are actual orders so if there is a null it will not be on the Report.

I did what you said and it did not work. For the first time your solution did not work for me...now it is scary!lol

 

[lbass]

How are you summarizing the formula?

-LB

 

[Ladyazh]

I am not sure how to answer.
I am using THE formula.

But there IS field that has a zero but this field does not included in calculation like:

PG EQUIV TOTQTY AMT
PG 1 1 99
PG 1 43 9100
PG 1 6 0

But formula I presented does not even touching this field.
Report does not have a grouping on this field.
I am confused and thank you for helping.

 

[lbass]

If you are showing all the fields contributing to your formula then the results should be:

PG EQUIV TOTQTY Your Formula
PG 1 1 1
PG 1 43 43
PG 1 6 6

What do you actually see?

-LB

 

[lbass]

If you are showing all the fields contributing to your formula then the results should be:

PG EQUIV TOTQTY Your Formula
PG 1 1 1
PG 1 43 43
PG 1 6 6

What do you actually see?

-LB

 

[Ladyazh]

I am inserting Total on this formula and get 44 as 43+1 WHERE 6 gets ignored because of 0 at AMT??? Does it make sense? Not to me.
Thanks.

PG EQUIV TOTQTY AMT
PG 1 1 99
PG 1 43 9100
PG 1 6 0

 

[lbass]

Please add your formula results to your example.

-LB