Hello
I would like the following expression to interact with my master calender, but as the 2nd part of the expression cannot be a sum, I have tried using the Only function, but at this time I return no results
Could you kidnly take a look at the expression and let me know how I can get teh second part of the calculation to interact with the master calender?
Num(Sum({$<FactDateNum = {">=$(=v_Start_Date_Outpatients)<=$(=v_End_Date_Outpatients)"}>} Outpatient_Referrals.REFERRAL_TOTAL/
Only({$<FactDateNum = {">=$(=v_Start_Date_Outpatients)<=$(=v_End_Date_Outpatients)"}>} Outpatient_Referrals.Population_Stats1/1000)),0)
Kind Regards
Helen
Hi Helen
It's hard to answer without seeing your data model, but what are you expecting for the second part of expression to return if there are two or more distinct values?
Lukasz
If Only() doesn't work, try Min() or Max().
In case of one value you have same result. In case of several values - it could be wrong result, but only you can understand how to handle this stuff.
Regards,
Sergey