Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi guys,
I stuck with a simple issue... I thought it is simple:
How can i bring the Min value to all lines?
And I managed with rank to have Min value.
I have set analysis in the KPI --> {$ <[AbsAll.CODE]={'9042'}>}.
No Result:
Min(Total <[HR.PERSONALNUMMER]> Aggr(Only({$ <[AbsAll.CODE]={'9042'}>} [HR.KalenderDatum]) ,[HR.PERSONALNUMMER]))
Wrong because Min over all lines:
Min( {<[HR.PERSONALNUMMER],[HR.KalenderDatum]>} TOTAL {$ <[AbsAll.CODE]={'9042'}>} [HR.KalenderDatum])
Hi @berndjaegle ,
what about this expression:
=Min( {< [AbsAll.CODE] ={'9042'} >} TOTAL <[HR.PERSONALNUMMER]> [HR.KalenderDatum] )
I hope it can help.
Best Regards
hi
you can try
Aggr(nodistinct Only({$ <[AbsAll.CODE]={'9042'}>} [HR.KalenderDatum]) ,[HR.PERSONALNUMMER]))
Gives no result. Also tried MIN arround the statement.
Hi @berndjaegle ,
what about this expression:
=Min( {< [AbsAll.CODE] ={'9042'} >} TOTAL <[HR.PERSONALNUMMER]> [HR.KalenderDatum] )
I hope it can help.
Best Regards
Hi agigliotti, this is it! Thanks a lot for your help! This community rocks!
Best regards,
Bernd