Help in Expression?

[narender123]

Hi All,

I have made a calender which is  based on "receipt data" of a table.

There is a paid date in another table.

doc  id   receive date      amount

12        5-1-2012          100

13        5-3-2012           200

25        26-2-2012          288

---------------------------------------------------------------------------------

doc  id   paid date      amount

12        7-1-2012          100

13       5-4-2012           400

14       29-6-2012          888

-------------------------------------------------------------------------------------------

I want to calculate amount where receipt date and paid date both are of the same month.

for those where receipt date and paid date are not belong to same month then not show there amount.

if i select september month then only show those amount whose paid date and receipt date fall in the same month.

Please suggest me to sort out this.\

Thanks in Advance.

Narender

[bbi_mba_76]

Hi,

to simplify you could add a Period field in the script, ie year*100+month.

[salto]

Hi,

Load

      "doc id" as DocID,

     "receive date" as ReceiveDate,

     Month("receive date") as  MonthReceived,

     "amount" as AmountReceived from RECEIVED_Table;

Load

      "doc id" as DocID,

     "paid date" as ReceiveDate,

     Month("paid date") as  MonthPaid,

     "amount" as AmountPaid from PAID_Table;

And set the expression to show only those DocID where MonthPaid and MonthReceived fields are the same.

Hope this helps!

[#4]

Hi,

Which amount you want to show amount belonging to the received date or amount belonging to the paid date?

Or in your case both the received date and paid date is in same month then the amount also same ah?

please explain once

[narender123]

Hi BBI_MBA,

Sorry i didnt get your point.please expalin with example.

Thanks

[narender123]

And set the expression to show only those DocID where MonthPaid and MonthReceived fields are the same.

how to achiave it as you said in bold letter.I have already joined but theproblem with the expression to show both date are of same month.

Thanks.

[salto]

PFA my approach.

Hope this helps!