HELLLPPPP Pllleeeaaasssseeeee

[samvile18]

Afternoon all,

I've been trying to write some syntax in one of my apps that will allow me to compare weekly results with the previous week. For some reason I can't get anywhere near what I'm trying to achieve, I'm fairly sure I've done something similar to this in the past but I can't find it anywhere!!

This is what the data looks like:

So I'd like to be able to show the variance to the previous load date etc...does that make sense?

This feels fairly simple and I'm sure I'm being a total idiot!

Any help will be greatly appreciated. 

[dmac1971 · Accepted solution]

Hi in a straight table use the above function to capture the value from the previous date : Above(Sum([# Customers]))

Your expression will be Sum([# Customers]) - Above(Sum([# Customers])) :

[samvile18]

You legend...why was I going for the most complex of solutions. Thank you very much