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 Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

table calc between dates

Status
Not open for further replies.

mart10

MIS
Nov 2, 2007
394
GB
I am using CR 2013

I have some exchange rates and I need to compare the output between 2 dates on the SAME row. I run the rport between 2 dates, so this is what I need

date 1 date 2 diff

USD 1.3 1.35 0.05
xxxx
yyyy
etc

If you do this in normal way then the data shows underneath on separate rows but I need a row per currency

I did try a cross tab report which does lay it out in format required BUT I cant seem to create the difference in the cross tab

Any ideas please?
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top