Need Help

[narender123]

Hi All,

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

There is a paid date also.

receipt date   paid date      amount

1-1-2012        5-1-2012          100

25-2-2012      5-3-2012           200

20-2-2012      26-2-2012          288

--------

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

[narender123]

Thanks Anant but the  receipt date and paid date are belong to different tables so i cant make flag.

So plaese advice .

Thanks

[swuehl]

i have used this expression.

=if(monthstart(Date) = monthstart(event_date),sum({<REGIME={'C*'} ,TAX_CODE={'VT'} >}TAX*-1))

But its showing "_".

It's almost never a good idea to use an aggregation inside an if statement if you want to filter your records you want to aggregate,

Your second version uses an aggregation inside an aggregation which is not allowed without using advanced aggregation (aggr() function).

try:

=sum({<REGIME={'C*'} ,TAX_CODE={'VT'} >} if(monthstart(Date) = monthstart(event_date), TAX*-1))