October 10, 2006 at 7:15 am
I have a scenario wherein I wanted to add the values of distinct transaction number, how do I do that. i.e.
Here in the example below, Each transaction is of two rows.If for same transaction on same date there are number of work reports then I am hiding the first row because it repeats. All that I want is to add the distinct values as shown the example below,
Financial organisation (GROUP (Company))
12/31/2003 606.60 approved 123 (Transaction Number) (1st Row)
5643577(Wok Report) (2nd Row)
01/05/2004 1000.00 approved 124 (Transaction Number) (to Satisfy $1000 three work reports were raised)
5643500(Wok Report)
5643501(Wok Report)
5643502(Wok Report)
02/05/2004 2000.00 approved 125 (Transaction Number) (to Satisfy $2000 three work reports were raised)
5643300(Wok Report)
5643301(Wok Report)
5643302(Wok Report)
Total 3606.60 (Total per Company group)
I want to add the visible row values only. Because the 1000.00 and 2000.00 was repeating for 01/05/2004 and 02/05/04 I am hiding the repeated values.
Please help me completing the above task.
October 13, 2006 at 8:00 am
This was removed by the editor as SPAM
October 18, 2006 at 8:53 am
What is the logic that you are using to hide the repeat cells?
October 20, 2006 at 2:40 pm
I am checking existing row value with the previous row value and hiding the repeated one.
The above posted problem is solved. I have created two functions in Report properties ,Code which gets the first value and adds. The second function assign's it to zero.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply