1 of 1 people found this helpful
Difficult to answer without seeing the structure of your data. With that said, the first calculation could be a problem as this is operating at the row level (there's no aggregation - sum, max, etc), so number of records (i.e. rows) will always be 1.
IF([TimeOutBRDays])<5 THEN 1 ELSE 0 END
and sum([field 1)/sum(field 2)
Don't multiply by 100 - let Tableau handle this as a percent.
If that doesn't help, then if you can post some of the data and the 'expected' result from this data, that would really let us see what needs to be done.
Don't you love the smell of Tableau on a Sunday morning? I need more coffee.
Thanks for the response. I altered a bit what you suggested and found that the following gave me what I wanted
The calculated field: IF([TimeOutBRDays]/[Number of Records])<5 THEN 1 ELSE 0 END was named [Return_5_Days] and dividing by the calculated field [CountRDate] works with the SUM operator for the row level field. Thanks again. David