Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
i tried the whole day to get this done and didnt found anything useful. So i hope you can help me here with a link or solution.
I have a relation over 3 tables and want to sum a value with a condition on another field and distinct ids.
I made a table, which include alle the data:
To get a number of the matching fields i made this: Count(DISTINCT{1<Validierungsergebnis={'Fehler'}>} [SchadenID]))
My problem:
How can i calculate the sum of the value "Schadenssumme" with distinct SchadenID and Validierungsergebnis={Ok'}?
I tried several aggr and sum versions. Mabye s.o. can help me thx a lot in advance
Binger
maybe like
=sum({<Validierungsergebnis = {'Ok'}>} aggr( only({<Validierungsergebnis = {'Ok'}>} Schadenssumme), SchadenID))
But I am not really sure what you want to achieve. Could you upload a more detailed explanation of your data model or input data and what you want to get as result?
maybe like
=sum({<Validierungsergebnis = {'Ok'}>} aggr( only({<Validierungsergebnis = {'Ok'}>} Schadenssumme), SchadenID))
But I am not really sure what you want to achieve. Could you upload a more detailed explanation of your data model or input data and what you want to get as result?