Avg 3 months sales

[Venkatesh_5990]

Hi All,

Need your help for below expression:

Current month closing value/(last 3 months avg sales value)/3*30 

this above logic should be like below one, can you please make it as like :

num(((sum(Closing_Value)/1000)/(sum(Sales_Value)/1000))
*
if(GetSelectedCount(Month)=0 or GetSelectedCount(Month)>1,round(num(max(Date_SecSales_Monthend)-MonthStart(min(Date_SecSales_Monthend)),'#,##0')),
num(max(Date_SecSales_Monthend)-MonthStart(min(Date_SecSales_Monthend)),'#,##0')),'#,##0'))
 

Thanks in advance.

[edwin]

what is the intent of this expression?

if(GetSelectedCount(Month)=0 or GetSelectedCount(Month)>1,round(num(max(Date_SecSales_Monthend)-MonthStart(min(Date_SecSales_Monthend)),'#,##0')),
num(max(Date_SecSales_Monthend)-MonthStart(min(Date_SecSales_Monthend)),'#,##0')),'#,##0'))

what is this field?  Date_SecSales_Monthend?

also why do you need help?  what is the problem specifically?