Conditional aggr expression

[#1]

Hello guys,

I am trying to do a conditional aggr function but failing.

I am trying to filter on salesman_id to find out what days he has worked.

I then wan to calculate the total sales by all salesman for that day.

e.g. in the attached spreadsheet, salesman Id 2005 has worked days 1,4,7,9 etc

I remove the filter from salesman ID and put the filter on day 1.

I then get the total of List Price for day one which is 90483.

I am struggling to put this in my expression, please help

thanks

[swuehl]

You're welcome.

Please note that my expression will only take days into account, where sum([List Price]) per Salesman ID is larger than zero. If your Salesman do work without resulting in revenue / [List Price] value, this will not work.

[#3]

Thanks for the tip Stefan.

I should be OK as I don't have null or - values.

thanks