Event SE_LOG: Expression Error

[infosense_devel]

Hello,

when I am accessing my QVW file from access point one of my chart object give an error,

SE_LOG: Expression Error. Doc: 02.Published/O2C Analysis.qvw, ObjectId: Document\CH367, Expr(0)

From windows event viewer:  Event id 300

Thanks in Advance...!

[Anil_Babu_Samineni]

Could be the cause Upgrade issue, Can i know the expression you used for that object 367??

[infosense_devel]

Please find below expression:

=Sum ({<REC_TYPE={GTNRec},ACCOUNT_GROUP={'Gross Sales'},GCC_SEGMENT3-={3801},Common_Year = {'$(vDSOEPriorYear)'},Common_Date = {'>=$(=min(AddMonths(=min(MonthStart(Common_Date)),-12))) <=$(=max(AddMonths(today()-1,-12)))'}>} RAGLDA_ACCTD_AMOUNT)

below is another expression which is not giving error in same chart:

=Sum ({<REC_TYPE={GTNRec},ACCOUNT_GROUP={'Gross Sales'},GCC_SEGMENT3-={3801},Common_Year = {'$(vDSOEMaxYear)'}>} RAGLDA_ACCTD_AMOUNT)

[Anil_Babu_Samineni · Accepted solution]

I didn't understand this part at all. Could be issue over here. May be this?

Common_Date = {'>=$(=min(AddMonths(=min(MonthStart(Common_Date)),-12))) <=$(=max(AddMonths(today()-1,-12)))'}

Common_Date = {'>=$(=AddMonths(Min(MonthStart(Common_Date)),-12)) <=$(=Max(AddMonths(Today()-1,-12)))'}

Final Expression Should be this, May be

=Sum ({<REC_TYPE={'GTNRec'},ACCOUNT_GROUP={'Gross Sales'},GCC_SEGMENT3-={3801},Common_Year = {'$(vDSOEPriorYear)'}, Common_Date = {'>=$(=AddMonths(Min(MonthStart(Common_Date)),-12)) <=$(=Max(AddMonths(Today()-1,-12)))'} >} RAGLDA_ACCTD_AMOUNT)

Note: You may getting error like Nested Aggregation.