Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Transformer - Monthly Change Measure with currency conversion

Status
Not open for further replies.

mesfall

MIS
Oct 24, 2003
1
US
Hello,

We have a fact table which has a measure called Reserves. We also need one which shows the Change in Reserves from one month to the next. This cannot be done in the fact table as we use cognos currency conversion so any differences due to currency fluctuation would be lost.

We want the Reserve measure to be converted and then the Change in Reserves measure to be calculated from it. Is there a way of calculating the Change in Reserves measure so that it would be done after currency conversion?

Thanks!
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top