Expression Error !!

[nikhilgarg]

Hey,

I am having a dummy database where i am calculating insurance claimed by female.

I am using following expression but no data is being displayed. Please help

Count({<Product = , [Customer Gender] = {"Female"} , [Maturity Year] = {2014}>}[Customer Name])/Count({<[Customer Gender]={"Female"}>}[Customer Name])

And also i want to compare with MAturity Year <=2014 but when i used [Maturity Year] <= {2014} , it gives me error.

Please tell what to do ??

Thanks

[senpradip007]

Try like

Count({<Product = , [Customer Gender] = {'Female'} , [Maturity Year] = {2014}>} [Customer Name])

/

Count({<[Customer Gender]={'Female'}>} [Customer Name])

[Anonymous]

Count({<Product = , [Customer Gender] = {'Female'} , [Maturity Year] <= {2014}>} [Customer Name])

/

Count({<[Customer Gender]={'Female'}>} [Customer Name])

[maxgro · Accepted solution]

for maturity add to set analysis

[Maturity Year]={"<=2014"}