Month wise resultant stock

[#1]

Hi all,

I want to show the difference between the maxday stock and minday stock for each month for the selected year.

Please find the attachment here for more details..

Thanks in advance for any help.

Regards

Kumar

[tresesco]

PFA.

Hope this is what you want.

[Anonymous]

Do you mean you want to see the difference between the highest amount of stock and the lowest amount of stock that has been kept in the system for a year and month ?

Is Max(Stock)-Min(Stock) not enough ?

Jonathan

[#4]

Hi tresesco,

This is the solution that i am looking for.

But it is not working with the actual data.

Can you please look at the attached application for your reference and let me know the problem.

Thanks

Kumar

[#5]

Hi Jonathan,

Not like that,

I need the difference of month wise maxday stock,minday stock.

Hope you are clear with my requirement.

Regards

Kumar

[Anonymous]

The dimension you added to the last application you posted (Stock_Month) does not exist.

Jonathan

[#7]

Ok,

Please find the new attachment here.

Regards

Kumar

[Anonymous]

I think the problem is that (according to the reference manual):

"If more than one value of expression share the same lowest sort-order, the function will return null."

I assume this means that there are multiple Stock values for the lowest date. Can you make the date field a datetime field instead ?

This will increase the size of your datamodel, so you may want to only include such a field for the earliest and latest transactions using some group by and min(), max() commands in the script.

Jonathan

[#9]

Can u attach a sample file.

Regards

Kumar

[nizamsha]

try            ths