Hi everyone,

I have a formula that multiplies the number of pieces produced by their price, for each row. The problem is that sometimes the price was not entered in the database, so it's zero. I have suppressed the details section, so that only the total is shown. I would like to make a formula to insert on the group footer, that warns us with the legend "incomplete" whenever there's a line with an article price as zezro.

Example

Details section (suppressed)

Pieces   Price    Pieces * Price
2        10          20
3        10          30
5        0            0
5        5            25
4        1            4
8        5            40
9        10          90

Group footer

                  Total
                   209           "incomplete"
                                   This is what I want to be shown, since we have a price zero at the first line of the 5 pieces. If all the pieces had a price, this legend would need to be hidden. So the formula has to be conditional.


Thanks a lot,
Santiago

Hi

I don't think the formula which you have placed in group footer will not work all the times. Because, it always pull group last record price then it compares it with zero.

Do the following to avoid inaccurate results :

The same formula you place it in detail instead of in group footer, then create below formula and place it in group footer.

Maximum({@formual},Groupname)

Thanks,
Sastry