Purchase/Consumption Calculation expression.Monthwise

[rohitians]

Hello,

I have an existing report where in we are displaying purchase and consumtion location wise,

but now we want the report to be displayed month wise i.e the month dimension is to be added,

but as i add the month dimension the opening and closing inventory values is not correct,,,,

I am attaching that report in another qv file please help where in i need to make changes so that correct inventory is displayed..

Thanks and Regards,

Rohit Yadav

[sujeetsingh]

Rohit ,

First of all  it seems there is some issue in sample given by you .

Please post a correct sample,

[rohitians]

Hello,

For opening inventory the code is..

(Sum({$<FinancialYear=,MonthName=,Quarter=,PostingDate ={"<$(=(Min(PostingDate)))"}>}  Cost_Amt_Actual)+

Sum({$<FinancialYear=,MonthName=,Quarter=,PostingDate ={"<$(=(Min(PostingDate)))"}>}  Cost_Amt_Expected))/100000

for closing inventory i have code as

(Sum({$<FinancialYear=,MonthName=,Quarter=,PostingDate ={"<=$(=(Max(PostingDate)))"}>}  Cost_Amt_Actual)+

Sum({$<FinancialYear=,MonthName=,Quarter=,PostingDate ={"<=$(=(Max(PostingDate)))"}>}  Cost_Amt_Expected))/100000

now when i introduce month as dimension it does not displays values correct i need to make changes to this code but not able to figure it out ....

Thanks and Regards,

Rohit

[sujeetsingh]

Its seems you are using Month name in set analysis for exclusion.