Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
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,
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,
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!