Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Hi, just edit part
[SludgeSampleDate]>=today()-365
to
[SludgeSampleDate]<today()-365 and [SludgeSampleDate]>=today()-730
I tried that, but it didn't work. Then I pasted yours and realised I was a bracket out! Thanks a lot.
Hi, just edit part
[SludgeSampleDate]>=today()-365
to
[SludgeSampleDate]<today()-365 and [SludgeSampleDate]>=today()-730
I tried that, but it didn't work. Then I pasted yours and realised I was a bracket out! Thanks a lot.