Thanks, the above seems to take care of point 2 above "Not seeing Ins if there are no Outs, although still show blank gaps in the report. Not sure if there are any way of getting rid of the blank spaces. The formulae seems hise all the data but leaves blank gaps on the report.
Point 1 is still...
On the first point I am happy with the result; it shows the ins and outs as required, although if for example there are two ins on the same day then I get the same result twice on the report.
On the 2nd point I get the In line with the 0%, although was hoping not to see Ins if there are no Outs.
Thank you very much for the above and the result is almost what I need.
It comes down to the 80% and yes you are correct in that I do have additional "in" values during the 5-day period. The result I am getting at the moment is working fine the only thing I can't get rid of is the duplicates...
Ibass,
Thanks for the response, You are correct in that I will have different client codes and different cash account number. I have added the client code and Account numbers in the mock data. I distinguish between "Ins" as positive amounts and "Outs" as negative amounts.
I have attempted to...
Hi I am new to Crystal reporting and hoping somebody can help with a query.
I am writing a report to report rapid "in and outs" in cash accounts, but am having problems in getting my rapid outs of the account as I need to identify cash that have gone out of the account within five days of the...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.