Skip to main content
Announcements
Customer Spotlight: Discover what’s possible with embedded analytics Oct. 16 at 10:00 AM ET: REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
pragyaagrawal
Partner - Contributor III
Partner - Contributor III

Why My Set Analysis not wokring

I have to sum up  field-A where Prod_Month is (> (Period_Month - V_Period_Length)<=Period_Month) and there are other criteria too ( Status = P , Age<=  V_Period_Length and Counter <= V_Period_Length).

i am using below expression:

sum({$*<

[Status]={'P'},

[Counter]={'<$(V_Period_Length)'},

[Age]={'<$(V_Period_Length)'},

PROD_FISCAL_MONTH=,

PROD_FISCAL_YEAR=,

PROD_FISCYEAR=,

PROD_MONTH=,

PROD_DATUM=,

PROD_CALYEAR=,

PROD_CALQUARTER=,

PROD_CALMONTH=,

PERIOD_MONTH=,

PERIOD_MONTH_FORECAST=,

PERIOD_FISCAL_YEAR=,

PERIOD_FISCALMONTH=,

[Prod_Month] = {"<=$(#=DATE(MAX(DATE(PERIOD_MONTH))))>$(#=DATE(DATE#(MONTHEND(DATE(MAX(DATE(PERIOD_MONTH)),'DD.MM.YYYY'),-$(V_Period_Length)),'DD.MM.YYYY')))"}

   >} ANZRW)


I am using this expression in straight table in column named "With Prod_MOnth Filter" where Dimension is

=Date(addmonths(PERIOD_MONTH,-(V_Period_Length-1)), 'MM.YYYY') &' -'&chr(10)& Date(PERIOD_MONTH, 'MM.YYYY')

Problem is this expression is returning right result only if i select PRIOD_MONTH specifically otherwise wrong result. Kindly help here.

Del.png

Thanks,

Pragya


0 Replies