Set Analysis

[chibi]

I have two date one is the Date, Month that I use for all calculations and references and the other is draw_end_date, Draw Month. Now I have an average calculation below;

Avg(Aggr((Sum(tkt_amt))/count(draw_id),draw_end_date))

But instead of showing the value based on draw_end_date and Draw Month it is still somehow capturing the Month that was already set for everything. 

Is there a way I can create a variable to ignore the "Date" or "Month" field in this calculation and only take into consideration the Draw Month & draw_end_date field?

[anat]

Can you bypass those 2 fields in ur expression

[chibi · Accepted solution]

Yeah I actually realized it works now. The numbers were odd because the data was missing