locked
Cumulative upto prev month RRS feed

  • Question

  • User-146807150 posted
    Proj	 ID	Desc	Plan_date	Qty	Prev_Month      Cumulative	Prev_Cumulative	   Curr_Mon	
    O11001	  1	Pile	NULL	       NULL	NULL	         NULL	           NULL	           NULL	
    O11001	  1	Pile	2013-01-01      200	0	         700	           700               0	
    
    O11001	  1	Pile	2013-02-01      -100	-100	         600	           600               0	
    O11001	  1	Pile	2013-03-01      100	0	         700	            0	           100

    this is my result set i want to display prev month details , and current month details and cumulative upto prev month.

    Observe the 2 & 3 rd line of result set i have a cumulative upto prev_month is 600...

    How to display this ,

    In some case's i don't have feb-13 records in that case i want to display the jan-13 records ...

    How to achieve this ....

    Any help out of this ....

    thanks in Advance....

    Tuesday, March 5, 2013 3:56 AM

Answers

  • User-67082742 posted

    You can write an IIF statement in the column linked to Curr_Month column

    eg: IIF( IsNothing(Fields!Curr_Month.Value), LookUp("2013-01-01",Fields!Plan_Date.Value,Fields!Curr_Month.Value,"DatasetName")

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Tuesday, March 5, 2013 9:02 AM