Exclude Fields

[smilingjohn]

HI All ,

I just want to ignore the filter (FILED) selction for my chart

and my expression is

=Round(sum({<PERIOD_NAME =>}EXTENDED_AMOUNT_IN_INR)/((Today()-('01-04-' & (max(PERIOD_YEAR)-1)))*(('01-04-'& max(PERIOD_YEAR)))-('01-04-'& (max(PERIOD_YEAR)-1))))/

sum({<PERIOD_NAME =>}ITM_VALUE)

after implenting this the filter PERIOD_NAME is still affection the values , Can please someone modify this .

When i use just  sum({<PERIOD_NAME =>}EXTENDED_AMOUNT_IN_INR)

for this expression it ignore the Filed selction PERIOD NAME .

[Anonymous · Accepted solution]

you may need to provide the set Analysis with ignore field PERIOD_NAME as well for the data functions

max({<PERIOD_NAME =>}(PERIOD_YEAR)-1) etc.

[jonathandienst]

I expect you need to include the override for PERIOD_NAME in all the Max() statements as well

..... max({<PERIOD_NAME=>} PERIOD_YEAR) .....

[smilingjohn]

Thanks Rudolf