Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
In the picture below i want the following output as my result in the 7e column:
Arnhem: 8 (Delta)
Rotterdam: 1 (Delta)
I used the following expression in the 8e column: COUNT(TOTAL<Region>Actual-Budget)
In the 7e column I used this expression in the function 'FieldValue' and looks like this:
FieldValue('Delta',Count(TOTAL<Region>Actual-Budget))
Now I known that 'FieldValue' looks after the LOAD order and not on the value order of this chart.
My question is what for expression is needed to give me the right output??
Hello,
Could you please elaborate on your criteria? Do you want to display the "8" because is the actual for Arnhem?
Regards.
My criteria is:
Last value of delta that is not null group by region.
So the result i want is 8 for Arnhem and 1 for Rotterdam.
Can you help me?
Hello,
The solution will be something like the following (with your own fields)
FirstSortedValue({< Actual = {'>0'} >} TOTAL <City> Actual, -MonthYear)
Without having a sample code, it's difficult to me to go further.
Hope that helps.
Your solution works fine, thank you!