pls help

[#1]

hi,

pls tell me what is the meaning of this statement.

num(sum( {$<STOCKYEAR= {'$(Vyera)'},STOCKMonth = {'$(Vmonth)'} ,YEAR=,MONTH=>} STOCK ),'#,##0')

[marcus_malinow]

Dushan

first off you have a num statement - this is there simply to format the result of the inner 'sum' expression as an integer.

the sum expression

- this is creating a sum of the field STOCK

- it contains a set analysis expression, the part within the {$< .... >}

- the set analysis is respecting your field selections except:

     STOCKYEAR is being set to the value of the variable Vyera

     STOCKMonth is being set to the value of the variable Vmonth

     selections in the fields YEAR and MONTH are being ignored

Hope this helps.

Marcus

[#3]

hi, I dont want to ignore YEAR and MONTH. How can I write this?

[marcus_malinow · Accepted solution]

The parts of the set analysis expression that are causing those field selections to be ignored are these:

YEAR=,MONTH=

If your chart contains YEAR and MONTH as dimensions this may be the reason for the selections to be ignored

[#5]

Thanks Marcus