Need help with some code

[GMFTM]

I am working with dates that I I have *** a numeric value. I am wanting to get a sum of values between two date ranges and divide that by another sum between to date ranges to get a value, that is ultimately a percentage.

Here is how I wrote it, but getting an error:

80Percent: IIF([YM] Beteen "201609" And "201701"),Sum(CountOfVIN))/IIF([YM] Beteen "201609" And "201703'),Sum(CountOfVIN))

 

[xenou]

The IIF stuff will work on the record level so I think you will get no results (since YM will never be between one date range and another non-overlapping date range at the same time). If it works at all. I rarely trust queries that use IIF in any kind of totals calculation.

 

[xenou]

It might be useful to see some sample data. Not entirely sure what metric you are going after -- average of percentages?