Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I'm trying to get a summary table set up so I can set up multiple charts
Issue I'm having is with this formula:
sum(Aggr([Working Days],[Employee Name],[Activity Date],[Start Date],[Job Title]))
My total results should be 726 - removing nulls from the Start Date. If I have the Start Date Dimension, it works fine. But in the Summary table with no dimensions, I get 728. Testing the data, I have 2 rows with no Start Date. I tried doing an extension of the expression (IsNull[Start Date])), expression) but get a 0 in return.
What else can I try?
Thanks.
Hi.
With the following test:
sum(if(num([Start Date])>0,Aggr([Working Days],[Employee Name],[Activity Date],[Start Date],[Job Title])))
Could you upload a sample to test.
Regards.
Try
if(IsNull[Start Date]<>0,sum(Aggr([Working Days],[Employee Name],[Activity Date],[Start Date],[Job Title])))
Rebeca
I tried that and it comes back with a 0.
Hi.
With the following test:
sum(if(num([Start Date])>0,Aggr([Working Days],[Employee Name],[Activity Date],[Start Date],[Job Title])))
Could you upload a sample to test.
Regards.
Perfect. Thanks!!