Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
My data should not change for a specific Search criteria.
My DATA should not change for r PROJECT_NAME,PROJECT_TYPE_LABEL,PROJECT_PHASE,WORKSPACE_TYPE_LABEL,BUSINESS_SPONSOR_NAME,BUSINESS_UNIT_LABEL
Here is my code :
if(wildmatch(only({1}CATEGORY_LABEL_SORT),20.5,24.5,21,0),'', Sum({$<PROJECT_NAME=,PROJECT_TYPE_LABEL=,PROJECT_PHASE=,WORKSPACE_TYPE_LABEL=,BUSINESS_SPONSOR_NAME=,BUSINESS_UNIT_LABEL=,CALENDAR_YEAR=,CALENDAR_PERIOD=,QuarterID ={"=$(=Max(QuarterID))"},FISCAL_YEAR = {"<=$(=Max(FISCAL_YEAR))"}>} DOLLAR_AMOUNT))
Does your formula work but is changing on selecting those fields?
My guess is that in your set analysis, your max function needs those fields ignored as well.
like:
Max({<PROJECT_NAME=,PROJECT_TYPE_LABEL=,PROJECT_PHASE=,WORKSPACE_TYPE_LABEL=,BUSINESS_SPONSOR_NAME=,BUSINESS_UNIT_LABEL=,CALENDAR_YEAR=,CALENDAR_PERIOD=>}QuarterID)
Do the same for FISCAL_YEAR
Remove any fields you don't need or add any you need.
Hope this helps!