topic Re: HELLLPPPP Pllleeeaaasssseeeee in App Development

HELLLPPPP Pllleeeaaasssseeeee

samvile18 — Fri, 07 Jun 2024 12:36:32 GMT

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.

Re: HELLLPPPP Pllleeeaaasssseeeee

dmac1971 — Fri, 07 Jun 2024 12:48:08 GMT

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])) :

Re: HELLLPPPP Pllleeeaaasssseeeee

samvile18 — Fri, 07 Jun 2024 12:52:53 GMT

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