7 Replies Latest reply: May 27, 2014 6:36 AM by sasi k

# Using identifiers and modifiers

Hi,

I am working with a sales report and I would need to show not only period and YTD figures but also full year figures.

What kind of set analysis I would need to write to be able to show full year figures? I would need to somehow be able to ignore period selection but include the year selection.

so below is simple example

PeriodValue

1

10
210

3

10
410
510
610
710
810
910
1010
1110
1210

So let's assume now it is period 5. My report should show periodic value 10, YTD value 50 and full year figure 120. How can I get that 120? it doesn't work with identifier full set 1, because then I would ignore all selections done and I would get data from previous years also. How to write: I want sum of seleceted year and ignore month selection?

Thanks

Regards

Janne

• ###### Re: Using identifiers and modifiers

If you just want to ignore period in current selection you can simply write in modifier

{\$<period = ''>Value}.so it ignore period filter.

Thanks & Regards

• ###### Re: Using identifiers and modifiers

Hi and thanks!

I think you are showing here the simple solution that I am looking for. However, it doesn't work

I have now following script:

sum({\$<Period=''>[Value]})

This doesn't work. I know I may have a stupid error there but I can't make this work

Thanks

Regards

Janne

• ###### Re: Using identifiers and modifiers

The right syntax is:

sum({\$<Period= >} [Value] )

JV

• ###### Re: Using identifiers and modifiers

That is the right solution! many thanks!

• ###### Re: Using identifiers and modifiers

Hi Janne,

don't put any thing after = sign

try this.

sum({\$<Period=>[Value]})

Thanks & Regards,

• ###### Re: Using identifiers and modifiers

Hi, try this:

1) sum( {< Period = {"\$(=max(Period))"}    >} Value)   --> current period

2) sum( {< Period = {" <=\$(=max(Period))"}    >} Value)   --> YTD

3) sum(  Value) for ALL periods. If you have different years then try:

sum( {< Period = , Year = {"\$(=max(Year))"} >} Value)

Thanks,

JV

• ###### Re: Using identifiers and modifiers

Hi janne

try some thing like

sum({< period ={"\$(=max(period))"}>} value)  --> for current Period

sum( {< period ={"<=\$(=max(period))"}>} value)   --> For YTD

sum({<period= >} value)      -----> For total sum irrespetive of the Period