Problem in Expression !!

[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

if([Maturity Year]<=2014,

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

Thanks

[sspe]

Hi,

Have you tried to troubleshoot it "step-wise"? I'd suggest that you start with e.g. just the first COUNT.... to see if that works. If that shows you some numbers, then you can try adding the IF statement and so on. Then you'll find which part of the statement that fails.

/Steen

[nikhilgarg]

HEy instead of above script i used this way:

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

But i want to comapre for Maturity Year <=2014 But it gives me error when i use <=.

WHat to do ??

[jyothish8807 · Accepted solution]

So write:

[Maturity]={"<=2014"}

REgards

KC

[#5]

Try this,

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

[PrashantSangle]

Hi,

If this expression works for you

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

then try for <= in set analysis

like

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

Regards