Set Analysis greater than less than

[Rydderski]

Hello Community, 

can someone please help out ? I am trying to find only values >=0<=50. This Set Analysis works  fine but as soon i try to add <=50 it does not work anymore. 

AVG({$<EBELN_EBELP = {"=Aggr(Max(EINKAUFSBELEGDATUM_EINKBELEG_KOPF),EBELN_EBELP) - Aggr(Max({$<OBJECTCLAS_BANF={'BANF'},FNAME_BANF={'FRGKZ'},VALUE_NEW_BANF={'2'}>} UDATE_BANF),BANFN_BNFPO) >=0 "} >}

Aggr(Max(EINKAUFSBELEGDATUM_EINKBELEG_KOPF),EBELN_EBELP)
-
Aggr(Max({$<OBJECTCLAS_BANF={'BANF'},FNAME_BANF={'FRGKZ'},VALUE_NEW_BANF={'2'}>} UDATE_BANF),BANFN_BNFPO)

)

Thank you very much!

[RafaelBarrios]

Hi @Rydderski 

Every time you try an  evaluation like <,<=,>,>=,*text* you need to use brackets and double quotes 

Sum({< num_field={">=0<=50"} >} sales)

hope this helps

best,

[RafaelBarrios]

Hi again,

Taking a better look, it’s not clear to me what you are trying to do.

If this gets to works, you should be using an IF

{"$(=if(Aggr1 -aggr2 >=0, do something, do something else))"}

But I think it should be

{"$(=if(sum(Aggr1) -sum(aggr2) >=0, do something, do something else))"}

Best,

[Rydderski]

Hello @RafaelBarrios ,

thank you for your reply. Maybe I should be more detailed, you are right. 

I want to calculate cycle times (DATE1-DATE2).  I want to calculate Avg(DATE1-DATE2).

Aggr(Max(EINKAUFSBELEGDATUM_EINKBELEG_KOPF),EBELN_EBELP) -> DATE1

Aggr(Max({$<OBJECTCLAS_BANF={'BANF'},FNAME_BANF={'FRGKZ'},VALUE_NEW_BANF={'2'}>} UDATE_BANF),BANFN_BNFPO) -> DATE2

In special cases DATE2 can have a higher value  than DATE1. In this case the output would be negative. I am trying to filter out negative cycle times by using >=0 but I want also the max value of ech cycle time to be 50. That´s why I have:

AVG({$<EBELN_EBELP = {"=Aggr(Max(EINKAUFSBELEGDATUM_EINKBELEG_KOPF),EBELN_EBELP) - Aggr(Max({$<OBJECTCLAS_BANF={'BANF'},FNAME_BANF={'FRGKZ'},VALUE_NEW_BANF={'2'}>} UDATE_BANF),BANFN_BNFPO) >=0 "} >}

Basically this is what is needed:

AVG(DATE1-DATE2) for each cycle time >=0<=50.

I hope this makes it a bit clearer. Thank you for your help!