expression for pivot table

[#1]

Hi all,

The Required O/p is mentioned in the excel with the label O/p. Kindly find  attached  excel .

Thanks!!!

[#2]

May i know what is the calculation of o/p measure

[#3]

Could you explain breifly

[#4]

Hi Saurabh,

So what is your question, do you want to know how O/p is derived?

If yes then divide Document by Actual

for example 100/0 is error so it is zero , 50 / 105 is 0.47 round it.

Regards,

NR

[#5]

1.

if(document>actual,actual)

2. i m confused with the 2nd conditon

here actual quantity is 105 for the same batch

1000060550

and in document we have 50 ,50,50 for the same batch. i have to break the quantity 50,50,5. need to start from max date.

[qlikpahadi07]

May i know what is the calculation/Logic for o/p

[#7]

Hi Saurabh,

Oder (Sort) the data by "Batch", "Posting Date_BUDAT" then put if condition get O/p then use Previous() on Batch to give 50,50,5

Please give a try and let me know if still you are not able to achieve the same.

Regards,

NR