Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear ALL, I have an issue, please advice if you know the answer.
I am struggling to find out the sum of first min date in my list:
It means that I need just 15 639 EUR.
The function that I use is:
=sum({<Date = {"$(=min(Date))", [Contract_ID]} >} [Lease Liability - opening])
, but it gives me (15 639+10 161) = 25 800, while I need just 15 639.
Please let me know which is the correct function to find it out.
Thank you.
Diana
Hi,
you have different values in the same min date. that is the reason you get the number. share the app to check
maybe you have a filter to get the expected output
As you can also see in image, you have 2 values corresponding to single Date.
May be it is coming due to that, can you check in your model?
Try this :
MinString({<date={"=$(=min(date)"}>} [Lease Liability - opening])
thank you for suggestion