Is this even possible - Get data based on another record....

[Ashenka]

Business Objects Reports Designer -
I have a table

Country, Currency code, Cost in Local, Cost in GBP
France - EUR - 100 - 150
France - USD - 200 - 325
America - USD - 200 - 325
India - INR - 500 - 5000
India - USD - 500 - 3000


HOW!? do i get all of France in to EUR?

in an ideal world, i would have a Country table with Base Currency for country, and an FX table, but i dont - is this even possible?

 

[Charliy]

It looks like you could group by country, total the GBP and then use you GBP to EUR conversion factor to get a total in EUR.

 

[Ashenka]

so if i have

Country, Currency code, Cost in Local, Cost in GBP
France - EUR - 100 - 150
France - USD - 200 - 325
France - GBP- 325 - 325
India - INR - 500 - 5000
India - USD - 500 - 3000


how do i get one line/record

Country, Currency code, Cost in Local, Cost in GBP
France - EUR - 700 - 900 (numbers made up)
India - INR - 1100 - 10000 (numbers made up)



etc

 

[Charliy]

by grouping on Country and putting everything in the group footer.

 

[Ashenka]

but where do i get the conversion rate?

this is what i want...


total Local Total GBP FX Conv to Country Rate
France AUD 825 1,500 1.82 1,886
France USD 64 100 1.57 126
France AUD 825 1,500 1.82 1,886
France GBP 600 600 1.00 755
France EUR 255 400 1.26 503
USA USD 4,462 7,000 1.57 10,983
USA AUD 5,500 10,000 1.82 15,690
USA USD 382 600 1.57 941
London EUR 318 400 1.26 400
London GBP 500 500 1.00 500
London JPY 38 7,000 185.19 7,000
London USD 6,374 10,000 1.57 10,000
London ZAR 1,451 25,000 17.23 25,000

total Local Total GBP
France EUR 5,156 2,569
USA USD 27,614 10,344
London GBP 42,900 8,680