Previous Day Sales

[evansabres]

I am trying to figure out 'Day of Event Sales' for events.

My fields are:

nwEVENTDTE (formatted as 10/13/2016)

Trans Date (formatted as 10/13/2016)

Net Sold Qty (numeric value)

I want to be able to take the final [Net Sold Qty] for a nwEVENTDTE and subtract out what the [Net Sold Qty] was on the previous day, giving me a 'day of sales' figure

Example:

nwEVENTDTE = 10/13/2016

Final [Net Sold Qty] = 18,000

[Net Sold Qty] as of [Trans Date] 10/12/2016 = 17,500

'Day of Game Sales'  = 500

Any suggestions would be appreciated.

[sunny_talwar]

Are you trying to do this in a text box or straight table? if it is a table, what are your dimensions?

[evansabres]

A table. Dimension would be nwEVENTDTE (formatted as 10/13/2016)

[sunny_talwar]

May be this

if table is sorted by ascending values of nwEVENTDTE

Sum([Net Sold Qty]) - Above(Sum([Net Sold Qty]))

if table is sorted by descending values of nwEVENTDTE

Sum([Net Sold Qty]) - Below(Sum([Net Sold Qty]))

[evansabres]

This does not provide the value I am looking for. This is taking the [Net Sold Qty] for the nwEVENTDTE of 10/13/16 and subtracting the [Net Sold Qty] for the nwEVENTDTE of the previous game.

What I am trying to do is find the [Net Sold Qty] for a nwEVENTDTE  the day before the nwEVENTDTE, which would be found in the field [Trans Date]

So, on transDATE 10/12/2016 there were 17,500 tickets distributed ([Net Sold Qty]) for nwEVENTDTE 10/13/16 and on transDATE 10/13/16 there were 18,000 ([Net Sold Qty]) tickets distributed.

I would call this total 'Day of Game Sales'

[sunny_talwar]

Can you share a screenshot of your chart? Do you have more than one dimension?

[evansabres]

The only dimension I would be using is nwEVENTDTE (formatted as 10/13/2016)

I haven't created the chart yet, so unfortunately no screenshot

[sunny_talwar]

Then how do you know what I have given isn't working?

[evansabres]

I meant that I had not created a functioning chart yet

[sunny_talwar]

I think you are using this

Sum([Net Sold Qty]) - Below(Sum([Net Sold Qty]))

Try this instead

Sum([Net Sold Qty]) - Above(Sum([Net Sold Qty]))