Dimention Object Formula

[Harlequin1]

I have 2 Dim Obj's (Code & District), a measure Obj (Amounts) & a Dim Obj I grouped called "Country".

For all those "N/A's" in the column "Country, I want to be able to divide their balances back (by using a % rate) into the other Country's.

Is their a formula I could use for that?

(Because "Country" is not in my Universe, I can't link it to a rate table in Excel. The problem is that I have few countries, but thousands of codes, with many Unknown Districts).

Orginal Report
Code / District / Country / Amount

1 Paris France 5,000
1 Madrid Spain 10,000
1 London UK 15,000
1 New York USA 15,000
1 Unknown N/A 5,000
50,000



Rate Table

Country Rate Apportioned To:

Unknown 5% France
Unknown 15% Spain
Unknown 30% UK
Unknown 50% USA


What the report should look like

Code District Country Amount Rate New Amt

1 Paris France 5,000 5% 5,250
1 Madrid Spain 10,000 15% 10,750
1 London UK 15,000 30% 16,500
1 New York USA 15,000 50% 17,500
1 Unknown N/A 5,000 -100% 0
50,000 50,000

 

[lbass]

Can you explain how the rates were determined? Or are they just established rates that don't relate to the original data? I thought you would be removing the Unknowns from the total and then creating a proportional distribution, but that doesn't seem to be the case.

Can you confirm that you are using Crystal Reports? What version?

-LB

 

[lbass]

I'm wondering whether you are using Business Objects and then you should post in Forum393.

-LB

 

[Harlequin1]

Thanks IBass. It should have been posted to "forum393: Business Objects solutions".

I'll post it there instead.

Regards