summing item stock value in a group

Jet Reports Historic Posts

August 13, 2013 19:06

None

Hi Guys

Having a little dilemma. Need to Sum items together in a group to get the valuation of stock.
.
The code below works fine providing I hard code the Date Filter.

=NL("Sum","Item","=NF(,""Net Change"",""Date Filter"",""..12/01/2013"")*NF(,""Unit Price"")","Item Division Code",$D8)

But when I use a cell reference i.e. $D$5 instead I get back an incorrect figure is this achievable?

Best regards

Date Votes

2 comments

Jet Reports Historic Posts August 13, 2013 21:03 Official comment

Hi,

Yes it should be achievable. I think you need something like this:

=NL("Sum","Item","=NF(,""Net Change"",""Date Filter"","""&NP("DateFilter",,$D$5)&""")*NF(,""Unit Price"")","Item Division Code",$D8)
I'm assuming that cell D5 actually has just the end date in this case and not the whole filter. Does that help?

Regards,
Hughes

Comment actions Permalink
0

Jet Reports Historic Posts August 13, 2013 21:33

That works, thank Hughes

Comment actions Permalink

Please sign in to leave a comment.