Set Analysis using Field Value

[#1]

I am very new to QV and set analysis.  I am trying to do a calculation based on a field value.  The statement I currently have

Avg({<[Issue Date]={'<=10/27/14'},[Exchg]={N}>}[Amount])  works with a hard coded date (10/27/14).  What I want to do is replace the date with a field (MyField) from my table that has a moving date.  In summary, I need to perform this calculation when Issue Date <= MyFieldValue

Anyone know how I can achieve this?

Thanks in advance.

[#2 · Accepted solution]

Hi L R.

Thank you for the attached file.

Look at my reply, your calculation is performed in two steps. This makes it less complex.

Step1 - differs records using conditional Type

Step2 - insert distinct Type in your set analysis:

Prior Calculation: Avg({<Type={'Prior'},[Issued in Exchange]={N}>}[Total Doc Amount])

Post Calculation: Avg({<Type={'Post'},[Issued in Exchange]={N}>}[Total Doc Amount])

This is a great way to perform conditional and f calculations.

I hope that will help you!

[#3]

Here's the example

[#4]

Hello Carlo,

Thank you so much.  That's exactly what I needed.