how to make Variable static ?

[santharubban]

Variable value shouldn't change when i select any filiters in app. This variable is derived expression.

[Nicole-Smith]

If you want your variable to be sum(Field), when you define it, define it as =sum({1}Field).  Then it should always have the total sum, not affected by selections.

[swuehl]

How does your variable definition looks like?

[MK_QSL]

You can lock it by {1} or ALL

i.e. Count({1}Customer)

or

SUM(ALL Sales)

[santharubban]

Hi all Thanks for your replys...

but it doesn't work. I have uploaded my variable value below

({1<NOT_IN_FR = {0},RPT_MON = p(DOS),SUBMITTER_ID = ,TAXONOMY_GROUP = , CLAIM_TYPE= ,REGION =, IPA_Type=,YEAR=,MONTH= >} DISTINCT ENCOUNTER_KEY)

[santharubban]

can anyone help me

[#7]

what value of your variable you expect when there is nothing selected? Doests it work then? You want to have part of expression in this variable or result of expression? For me it looks like part of expression ...

Try to write your expression in chart without using this variable. Does it work?

[MK_QSL]

Try

SUM(({1<NOT_IN_FR = {0},RPT_MON = p(DOS),SUBMITTER_ID = ,TAXONOMY_GROUP = , CLAIM_TYPE= ,REGION =,IPA_Type=,YEAR=,MONTH= >} DISTINCT ENCOUNTER_KEY))

or

COUNT(({1<NOT_IN_FR = {0},RPT_MON = p(DOS),SUBMITTER_ID = ,TAXONOMY_GROUP = , CLAIM_TYPE= ,REGION =,IPA_Type=,YEAR=,MONTH= >} DISTINCT ENCOUNTER_KEY))

or

AVG(({1<NOT_IN_FR = {0},RPT_MON = p(DOS),SUBMITTER_ID = ,TAXONOMY_GROUP = , CLAIM_TYPE= ,REGION =,IPA_Type=,YEAR=,MONTH= >} DISTINCT ENCOUNTER_KEY))

[santharubban]

Hi all,

plesae find the full expression,

num(((COUNT({1<NOT_IN_FR = {0},RPT_MON = p(DOS),SUBMITTER_ID = ,TAXONOMY_GROUP = , CLAIM_TYPE= ,REGION =, IPA_Type=,YEAR=,MONTH =,RPT_MON= >} DISTINCT ENCOUNTER_KEY)/
Count({1<SUBMITTER_ID = ,TAXONOMY_GROUP = , CLAIM_TYPE= ,REGION =, IPA_Type=,YEAR=,MONTH =,RPT_MON=>}IPA_MEMBER_ID))*12),'#,##0.##')

This variable value shouldn't change, when i select the filiter. It should be a static value, but when i select month the value is changing. 

[#10]

Isn't it p(DOS) associated with Month?

Try maybe something like

p({<Month=>DOS})

Look if after selections of Month possible DOS value list changes...

regards

Darek