Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I have the below expression:
sum({$<TransDate={"=firstsortedvalue({$<CashAmount={'>0'},DATE= {'<$(=OpeningDate)'} >} DATE,-DATE)"}>}Amount).
The firstsortedvalue returns one single date.Alone it works fine.But when i put it on the sum() i get the sum for all values(dates) of field TransDate instead of
get sum for only single date equal to TransDate.
Any help will be appreciate!
Hi Celambarasan and all other guys
a similar issue.
I want to show in the chart the sum of my amount at the last date of a month.
Example
MAT Amount Date
123 1 28.01.2017
123 5 28.01.2017
124 10 31.01.2017
125 7 31.01.2017
126 8 31.01.2017
Result should be:
Month Amount
01.2017 25