Exclusion in Set Analysis

[#1]

HI All

I am currently using this set analysis for calculating Netsales in a Straight Table

SUM( AGGR((Sum({<MONTH={'$(vThismonth)'}>}NETSALE))

now i need to exclude credits, with flag 1

exclude CR = 1

how to achieve this

i tried this but result not as expected

SUM(

  AGGR(

  (

  Sum({<MONTH={'$(vThismonth),CR -={1}'}>}NETSALE))

Please Suggest

[marcus_malinow]

You have an extra curly bracket after the CC -={1}.

SUM(

  AGGR(

  (

  Sum({<MONTH={'$(vThismonth)'}, CC -={1}>}NETSALE)

  /

  Only({<MONTH={'$(vThismonth)'}>}WORKINGDAYS)

  )

  ,BRANCH)

[Anonymous]

can you Show your complete expression

did you try the Expression?

AGGR(

  (

  Sum({<MONTH={'$(vThismonth)'}, CC -={1}}>}NETSALE)

  /

  Only({<MONTH={'$(vThismonth)'}>}WORKINGDAYS)

  )

  ,BRANCH)

if thisexpression results in 0

try the single expressions

Sum({<MONTH={'$(vThismonth)'}, CC -={1}}>}NETSALE)

and see the results

are the month Format identical?

[#4]

HI Marcus

I tried without the extra } but not showing any Values

[#5]

HI Rudolf

the Month fields are identical

when i use this below expression alone i am getting values

[Anonymous]

so let's summarize

you get a value when you use Sum({<MONTH={'$(vThismonth)'}, CC -={1}}>}NETSALE)

monthfield and variable are identical,

but complete Expression Returns 0

question: does your datamodel have a Connection between BRANCH and values?

               is the resulting number large enough >0 (or is NETSALES/NrOfWorkingdays)<1 and Expression is         defined as integer?

-> can you post example qvw?

[#7]

HI Rudolf

Your expression worked, Don't know  why it didn't work initially, I recreated the Straight table and it worked

might be i missed  some thing

SUM(

  AGGR(

  (

  Sum({<MONTH={'$(vThismonth)'},CR -={1}>}NETSALE))