topic Re: How to use first sorted value function() to add two values in App Development

How to use first sorted value function() to add two values

shri — Fri, 26 Apr 2019 09:49:43 GMT

I have attached some data , now in this, for example

ex: Material 1011 & 1012 has week = 2 (this is the case when you can select only 1 Material )

Firstsortedvalue(Avail.qty,+Avail.qty) whose result is 510

Firstsortedvalue(Avail.qty,+Avail.qty) whose result is 530

BUT

if you select Both 1011 & 1012 Materials in filter pane The values should get Added i.e. Result = 510+530= 1040

and this is the required result but the above expression doesn't work so please guide

Table:

And there is 1 more case where

firstsortedvalue (avail.qty,+avail.qty) of 1011 for week 6 is = 382 &

firstsortedvalue (avail.qty,+avail.qty) of 1012 for week 6 is = -125

& the result when i add these two , I should get Result = 382-125 = 257, but i am not able to get it.

Table:

So please help!!

sunny_talwar — Fri, 26 Apr 2019 11:35:22 GMT

Try this

Sum(Aggr(Firstsortedvalue(Avail.qty, Avail.qty), Material))

shri — Sat, 27 Apr 2019 04:01:03 GMT

It is adding the values now but in my data I have week 16 at the bottom which I have not attached & it is giving a null value for that week.

shri — Sat, 27 Apr 2019 06:44:07 GMT

Thank you I got the required result!! I had to make slight change in your expression

Exp : Sum(Aggr(Firstsortedvalue(Avail.qty, Avail.qty), Material))

I have used Exp: Sum(Aggr(Firstsortedvalue([Avail. qty], +[Avail. qty]),[Date_D.autoCalendar.Week], Material))
(since I have weeks as dimension)