Skip to main content
Announcements
Customer Spotlight: Discover what’s possible with embedded analytics Oct. 16 at 10:00 AM ET: REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

excluding/ignoring fields in set analysis

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

1 Solution

Accepted Solutions
Anonymous
Not applicable
Author

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

View solution in original post

8 Replies
MK_QSL
MVP
MVP

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

Anonymous
Not applicable
Author

Hi Manish,

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

it brought a different wrong result

MK_QSL
MVP
MVP

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
Not applicable
Author

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
MVP
MVP

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
Not applicable
Author

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
MVP
MVP

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

You may reduce data and attach sample file.

Anonymous
Not applicable
Author

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