Remove Duplicate value in a formula in the Detail section

[fredong]

I am using CR v.8.0 and I have created a formula and placed it in the Detail section that only retrieve data with the condition of the date parameter and warehouses and it has given me duplicate value because of the joint of the 2 tables and I need to remove the duplicate value or get the discinct value and and Sum it with the same Part#key. Below is my formula

--@Cost is the name of the formula
--{?EndDate} is the user date enter parameter

if {CostTier.PostDate} = {?EndDate} and {Warehouse.WhseID} like ["PS*", "NV*"] then
{CostTier.Cost}

--------------------Data Results in the Detail Section---
User entered {?EndDate} as 05/01/05

Warehouse @Cost PostDate Part#key
--------- ---- -------- --------
NVII 5.00 05/01/05 5038
NVII 5.00 05/01/05 5038
NVII 0.00 05/21/05 5038
NVII 0.00 05/13/05 5038
PSIA 6.00 05/01/05 5038
PSIA 6.00 05/01/05 5038
PSIA 0.00 06/01/05 5038
TTTA 0.00 05/01/05 5038
PSIA 6.00 05/01/05 5038
PSIA 6.00 05/01/05 5038
NVII 5.00 05/01/05 5038

Basically, I need to sum PSIA and NVII
with the total = 11.00 with the same Part#key.

Any ideas.Thanks.

 

[ebutter]

Select all objects in your Detail line.
Right click and select Format Objects.
Go to Common Tab.
Select Suppress Duplicates.

Open Section Expert.
Select Details.
Select Suppress if Blank.

At this point your rid of your duplicate lines. (Assume you can't tweak your Record Selection.)

You may well have to use Running Totals to get accurate results with your summaries because the suppressed lines may be included with the regular Summary function. Help has a decent description of how to use Running Totals.

ebutter

 

[fredong]

I have tried that and I am still getting duplicate value