Bolean required here error message.

[megbytes]

When i enter this formula, i get an error message "Bolean required here"


if Previous ({SummaryDash.ShipVal_USD}) = {SummaryDash.ShipVal_USD} and Previous ({@LineRelPack}) = {@LineRelPack} then
{SummaryDash.ShipVal_USD} = 0 else {SummaryDash.ShipVal_USD}

my report outputs multiple lines of detail records if there were multiple units shipped on the detail line. this creates an overstated revenue value so i was trying to set the value of the second and third lines to zero in order to not double/triple count the value shipped.

how do i deal with this error message.

 

[lbass]

It sounds like you placed this formula in a formatting area. You should instead be creating this formula in the formula editor->formula->new and using this formula instead of {SummaryDash.ShipVal_USD}.

However, if your goal is to arrive at a correct summary figure across records, you should instead be using a running total that sums the amount,evaluates on change of a formula:

Previous ({SummaryDash.ShipVal_USD}) <> {SummaryDash.ShipVal_USD} or
Previous ({@LineRelPack}) <> {@LineRelPack}

Not sure of the reset, but if it you are grouping on invoice, it should be on change of group: invoice.

You could also be suppressing the unwanted lines by using a detaili suppression formula like this:

Previous ({SummaryDash.ShipVal_USD}) = {SummaryDash.ShipVal_USD} and
Previous ({@LineRelPack}) = {@LineRelPack}

-LB

 

[megbytes]

Thanks for the reply, let me clarify some points:
My formula was a formula intended to be used in the detail section.
The multiple records are required on the report because they represent a 1 (Order detail lines) to many (serial number records associated with the order detail line).

so if an order line had 3 units with 3 unique serial numbers, i get 3 lines, repeating the extended price three times.

(Now that i think about it) i suppose i could use the unit price but it would be nice to understand the Boolean error message for future use.

Thanks LBass

 

[lbass]

But where did you create this formula?

Where is the cursor in the formula when you receive this error?

I think you need to show the content of the nested formula, also, to clarify the issue.

-LB