Combining two files result..

[gvenkat]

Hi,

The current situation

[CobaltSky]

One approach to this would be to put cash in and cash out into a single file, but clearly flag which is which (eg with an automatic dynamic background color). That would make the creation of summaries and reconciliations ver easy.

Alternatively, you could establish a relationship from a file (a new file or an existing file) to both cash in and cash out based on date (both driven by the same range field). That would enable you to place portals of the in and out transactions side by side, to create summary calcs for each portal, and to use these in a further calculation to arrive at a balance.

[gvenkat]

Ray,

Thanx for your information.

I now made a drop down to select "Cash IN" and "Cash Out" and accordingly I changed the calculation and now the storage of both cash-in and cash-out are in a single file.

When I worked to have a report for a particular range of dates, I am unable to place these two summary results side-by-side in a SINGLE layout.. Could you please give a solution for the same.

(It's giving only one set of result on a single layout)

--Venkat