Problem Regarding set analysis

[#1]

Hi All,

I want to calculate average salary from 1-Feb 2014 to till date i.e today()-1 .....How i can calculate in set analysis ....

I tried with the below code but did not get the proper answer :----

Sum( {<  Date={"$(=Makedate(2011,02,05)) "}   >}   SALARY)

Please check and do needful for me ..................

Sarfaraz

[ogster1974]

Try AVG({<Date={">=01/02/2014 <=Today()-1"}>} Salary)

[anbu1984 · Accepted solution]

Sum( {<  Date={">=$(=Makedate(2011,02,05))<=$(Date(Today()-1))"}   >}   SALARY)

[#4]

Thnaks a lot anbu .....your solution is working as expected .......and andy i tried with your solution also but did not work ....

Anyway thanks a lot for your reply !!!!!!!!!!

Sarfaraz

[anbu1984]

Please mark as answered/helpful if our replies resolved your query