Expression tweaking

[Sam_Thomas]

Hi

I have an expression that seems to be working just fine, where I determine the "Application Rate" for a number of sites. 

The expression is below:

=240/

(Avg(if(FullName='% Nitrogen',

if([SludgeSampleDate]>=today()-365, [DeterminandValue])) * 10)

*

(Avg(if(FullName='Dry Solids',

if([SludgeSampleDate]>=today()-365, DeterminandValue))) /100))

(As I say, this calculation is returning correct values - but may not be the most efficient way.)

This calculation gives me the rate based on sample results taken in the last year. I would like to add another column which tells me what the application rate was last year. So rather than using all samples from today - 365, I would like to use all data from samples between -730 and -365. 

How might I do this? Thank you in advance.

[justISO · Accepted solution]

Hi, just edit part

[SludgeSampleDate]>=today()-365

to

[SludgeSampleDate]<today()-365 and [SludgeSampleDate]>=today()-730

[Sam_Thomas · Accepted solution]

I tried that, but it didn't work. Then I pasted yours and realised I was a bracket out! Thanks a lot.