Set Analysis

[#1]

Hi Experts,

Can you correct the given expression ...

Year_Posting and Month_Posting are not working so getting 0 as my output.

Year_Posting , Year_Master_From , Year_Master_To

Month_Posting ,  Month_Master_From , Month_Master_To These are the fields. How to assign the field to other field. Getting wrong because of that only.

Kindly suggest.

=SUM( {<Year_Plan={$(vMaxYear)},Year_Posting={">=Year_Master_From <=Year_Master_To"},

Month_Posting={">=Month_Master_From) <=Month_Master_To)"},Month_Num_Plan={$(vMaxMonth)}, Flag_Plan={'ManuPlan'}>} Plan)

[Gysbert_Wassenaar]

My guess is that you're doing trying to compare fields on a record-by-record basis:

Year_Posting={">=Year_Master_From <=Year_Master_To"},

Month_Posting={">=Month_Master_From) <=Month_Master_To)"},

And that won't work. You'll have to replace those with if statements. Maybe something like:

SUM( {<Year_Plan={$(vMaxYear)},Month_Num_Plan={$(vMaxMonth)}, Flag_Plan={'ManuPlan'}>}

if (Year_Posting>=Year_Master_From and Year_Posting <=Year_Master_To and

Month_Posting>=Month_Master_From and Month_Posting <=Month_Master_To,

Plan))