Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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 ??
So write:
[Maturity]={"<=2014"}
REgards
KC
Try this,
Count({<Product = , [Customer Gender] = {"Female"} ,[Maturity Year]={'<=2014'}>}[Customer Name])/Count({<[Customer Gender]={"Female"}>}[Customer Name])
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