Looks like you are using this calculations based on fact table or might be physical columns.
I would suggest to use logical columns so that you can use the date(for received_date) column your day dim.
map the day dim to fact table and use physical expression for the same, its same as your other post with status=completed as I said in my last email.
You have to use timestampdiff function.
If helps mark
Edited by: Srini VEERAVALLI on Feb 20, 2013 2:47 PM