excluding/ignoring fields in set analysis

[Anonymous]

Hi All,

I have a set-analysis that sums material quantity for the last month of the selected period. this set should  not  calculate two of the fields (GsPeelings,GnPeelings).

i use this Set-Analysis to do so:

Sum({$<[Month Num]={$(=Max(Month))},GsPeelings={0}>+<GnPeelings={0}> }ACT_SubQnty)

It works well when I select one month but when I select more then one month period the result is wrong.

my guess is that the syntax ">+<" is the problem

would appreciate any help

thanks

Avner

[MK_QSL]

Sum({$<[Month Num]={'$(=Max(Month))'},GsPeelings=,GnPeelings=> }ACT_SubQnty)

[Anonymous]

Hi Manish,

thanks for the quick reply, but it didn't work.

it brought a different wrong result

[MK_QSL]

If you select more than one month, the result will be only for max month of the selection.

In case if you want result for all month... remove month field from Set Analysis...

Sum({$<GsPeelings=,GnPeelings=> }ACT_SubQnty)

[Anonymous]

that's true,

but i wish to present sum of selected months on one column, and on the other, present only last month's total.

sorry my explanation wasn't clear enought

[MK_QSL]

This will give you Max Month's SUM

Sum({$<[Month Num]={'$(=Max(Month))'},GsPeelings=,GnPeelings=> }ACT_SubQnty)

This will give you SUM for all selected months...

Sum({$<GsPeelings=,GnPeelings=> }ACT_SubQnty)

If still not correct, request you to upload your apps.

[Anonymous]

Hi manish,

thanks for your help, there's still problem with the calculation, uploading my model is a bit of a problem.

I'll check if i can sort it out

thanks again

[MK_QSL]

It's difficult to answer without looking upon your apps.

You may reduce data and attach sample file.

[Anonymous · Accepted solution]

Hi manish,

I used a flag to point out the peel section, so i don't have to create complex set

Sum({$<[Month Num]={'$(=Max(Month))'},Peel_Flag={0}> }ACT_SubQnty)

thanks again