Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear all,
I need to produce the report in attachment,
but I don't understand hot to do it.
I've problem dealing Initial Stock and final stock values.
Help please.
Thank in advance
S.
I suggest to add a listbox to select the month field; when you select Month 2 and 3 you get the initial for month 2 and final for month 3
Regarding a static formula, yes, I agree usually isn't a good option but maybe is wthat Steve wants
Also min or max Month could be a wrong option if there are many years......
may be februry total stock count is 255
and end of march stock count is 100
you can find how many stock sold and returned each month.
total stock sold each month
total stock returned easch month
etc
Hey there,
Maybe this:
Initial Stock:
Sum({<Month = {'$(=max(Month)-1)'}>} InitialStock)
Final Stock:
Sum({<Month = {'$(=max(Month))'}>} FinalStock)
See the attached file
Best regards,
D.A. MB
with your data you can make a chart with store as dimension, a listbox for Month field and these expressions
sum({$ <Month={$(=min(Month))}>} InitialStock)
sum({$ <Month={$(=max(Month))}>} FinalStock)
or, for a static chart
sum({$ <Month={2}>} InitialStock)
sum({$ <Month={3}>} FinalStock)
Your first expression will not work because you will get wrong values if you test it as it is, see the result:
Also a static formula isn't, in my personal opinion, a good option in a Dashboard.
Best regards,
D.A. MB
I suggest to add a listbox to select the month field; when you select Month 2 and 3 you get the initial for month 2 and final for month 3
Regarding a static formula, yes, I agree usually isn't a good option but maybe is wthat Steve wants
Also min or max Month could be a wrong option if there are many years......
Hi Maxgro,
your solution is good for me.
Just one thing: having more years, what I have to use instead min or max ?
Hi Muguel,
thanks for your help. Your solution has been useful for me.
Thank again