Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I have below MaxString expression which is working fine for each line.
= Maxstring( {< %BILLINGDOC=, KONV.KSCHL={'ZVSH'} >} KONV.KNUMH)
Now, I have to find max KNUMH value (for that I used above maxstring function) and sum up the respective KBETR values for each MEL numbers. So, I am trying to apply the same in advance set analysis which is not working.
= Sum ( {<
KONV.KNUMH={"= Maxstring( {< %BILLINGDOC= ,KONV.KSCHL={'ZVSH'}>} KONV.KNUMH)" }
>}
KONV.KBETR)
In my case it should show 0 i.e KBETR is 0 for for the KNUMH - 0322567585.
I think Maxstring function is not working in advanced set analysis. Any help or guidance is appreciated.
Note: Please do not ask me to upload the application which is not possible,
Edit: I have uploaded sample document
My mistake. Sample is working as expected. Unfortunately, the below one is returning the same result as above. I am just trying to play with your expression.
=FirstSortedValue({<%BILLINGDOC= ,KONV.KSCHL={'ZVSH'}>} Aggr(Sum({<%BILLINGDOC= ,KONV.KSCHL={'ZVSH'}>} KONV.KBETR), MARA_ENHANCED.NORMT, KONV.KNUMH), -Aggr(Rank(KONV.KNUMH), MARA_ENHANCED.NORMT, KONV.KNUMH))
Can you create a new table like this
Dimensions
MARA_ENHANCED.NORMT
KONV.KNUMH
Expression
Sum({<%BILLINGDOC= ,KONV.KSCHL = {'ZVSH'}>} KONV.KBETR)
and share a screenshot
Finally I understood what you want, after Sunny has put her solution) And here is another way
Sum(If(Cond = Aggr(Max(TOTAL<MEL>Cond), MEL, Cond), Sales, 0))
Here is the screenshot.
I wonder why 0322567585 isn't showing up within KONV.KNUMH? How about if you add this as a second expression
Sum({<%BILLINGDOC>} KONV.KBETR)
Yeah.
Sample file is working fine but when I applied the same in my application it is not working.
Sorry Guys. I would like to attach my file but I am not supposed to do it.
This is strange, I am confused as to why 0322567585 isn't showing up? Does it have a zero value for Sum({<%BILLINGDOC>} KONV.KBETR)
I was hurry so sorry for the confusion. Yes it is zero value (I have already mentioned in the question).