Stocke value report

[Anonymous]

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.

[#2]

may be februry total stock count is 255

and end of march stock count is 100

[#3]

you can find how many stock sold and returned each month.

total stock sold each month

total stock returned easch month

etc

[miguelbraga]

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

[maxgro]

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)

[miguelbraga]

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

[maxgro · Accepted solution]

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......

[Anonymous]

Hi Maxgro,

your solution is good for me.

Just one thing: having more years, what I have to use instead min or max ?

[Anonymous]

Hi Muguel,

thanks for your help. Your solution has been useful for me.

Thank again