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

 

[skrandel]

Doubt you can do this at all. Maybe with a couple of queries and some extra variables, but I think this is a database effort.

Steve Krandel
Intuit