Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
how to calculate both Opening stock and Closing Stock from one field?
Closing Stock = sum(Closing_stock) of Jul 2013 i.e 10000
Opening Stock = 10000 of Aug 2013
i.e the value I get as Closing Stock of Jul 2013 is same as Opening Stock of Aug 2013
eg,
July 2013 Aug 2013 Sep 2013 Oct2013
Opening Stock 0 10000 5000 0
Closing Stock 10000 5000 0 2000
I am calculating Closing Stock as Sum(closing_stock) . the table has only one value closing_stock , depending on closing_stock I have to calculate Opening Stock.
Make chart and take the months in Rows with expression same as mentioned by you.
it will provide you the required information.
rgds
Ashwani
Hi,
See the attachment.
Can you tell me how your data structure looks like?. Is something like this
Month OpeningStock ClosingStock
Jan 2013 10000 50000
Feb 2013 60000
Mar 2013 70000
If not can you provide the sample data?
its like this:
July 2013 Aug 2013 Sep 2013 Oct2013
Opening Stock 0 10000 5000 0
Closing Stock 10000 5000 0 2000
Hi,
Please find the attached file. Hope it helps you
Thanks and Regards,
Amuthabharathi.S
for closing stock use your standard expression and givt it a name (e.g. ClosingStock): sum(Closing_stock)
and for opening stock try: sum(Closing_stock) + above(ClosingStock)
I want in this format:
July 2013 Aug 2013 Sep 2013 Oct2013
Opening Stock 0 10000 5000 0
Closing Stock 10000 5000 0 2000
Hi,
You only need to put the check mark on Horizontal under presentation tab.
See the updated attachment.
Hi,
See the attachment whcih is what you are expecting. isn't it?