Set analysis

[#1]

Hi

i have problem in set analysis

my expression is

sum({<[GL Date]={">=$(=Start Period)"}>}[Net Amount])

here  Start Period  values are  periodstartdate,quarterstartdate,yearstartdate

all date fields are in timestamp format .

if im using expression like

sum({<[GL Date]={">=$(=periodstartdate)"}>}[Net Amount])

this expression working fine.

but problem with start period

how to use these type of values in setanalysis.

[#2]

hi

the Start Period is a Field then period,quarter and years is data ?

[sujeetsingh]

Please explain the outcome of your expression what you want.

[jyothish8807]

Try this,

sum({<[GL Date]={">=$(=[Start Period])"}>}[Net Amount])

Use a [ ] at Start Period.

Regards

Jyothish KC

[#5]

Hi

here start period values are period start date,quarter start date,year startdate,

these are also fileds

[er_mohit]

Try this

sum({<[GL Date]={'>=$(=Date([Start Period]))'}>}[Net Amount])

[#7]

Hi

i already try this,but this is also not working

here start period representing another field values

[#8]

i think the Start Period is Table name and the date,quarter and yearstartdate are field of Start Period ?

[NavinReddy]

sum({<[GL Date]={">=$(Start Period)"}>}[Net Amount])

remove '=' and try

[tresesco]

Please share your sample app.