Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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...
Try this
BillingDate_Num={">=$(=(QuarterStart(AddYears(Max({<Date_Flag={'ZSales'}>}BillingDate_Num),-1)))) <=$(=num(AddYears(Today(),-1)))"}
Try this
SUM(Month=, Quarter=, Year=, BillingDate_Num={">=$(=date(QuarterStart(Today(),-4))) <=$(=date(QuarterEnd(Today(),-4)))"}[GL Value])
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?