Set Analysis LYQTD error

[jayshrinipurte]

Hi Experts,

Please Help...

=num(sum({<[Sales Organization]={'1000'},[G/L acc. no.]={' ','','31010100','31010300'},[Customer Group]={'01'},[Category]={'F & F Blends-Special'},[Fin Year]=,[Cal Year]=, Month=, [Cal Quarter]=, Day=,

BillingDate_Num ={">=$(=num(QuarterStart(AddYears(Max({<Date_Flag={'ZSales'}>}BillingDate_Num),-1)))) <=$(=num(AddYears(Today(),-1)))"}

>}[GL Value])/10000000,'#,##0.00')

This Expression giving me Zero value...

[prma7799]

Try this

BillingDate_Num={">=$(=(QuarterStart(AddYears(Max({<Date_Flag={'ZSales'}>}BillingDate_Num),-1)))) <=$(=num(AddYears(Today(),-1)))"}

[neha_shirsath]

Try this

SUM(Month=, Quarter=, Year=, BillingDate_Num={">=$(=date(QuarterStart(Today(),-4))) <=$(=date(QuarterEnd(Today(),-4)))"}[GL Value])

[sunny_talwar]

It could be because you have no data that meet the criteria which is why you see 0? I mean just by looking at the expression it would be very difficult to know why you are getting a 0. Do you want to may be share more information? Or share a sample and explain what the expected output should be?