Calculated Dimension Problem

[tmumaw]

Help guys,

I have a calculated dimension to calculate the number of days between when the document was created and when the work was completed.  However for some reason it does not like my expression.

Thanks

Thom

=interval({<Final_Status = {C}>} WEDAT - [Document Date],'d')

[#2]

Are both parts of the formula in date format?

If C is a text value you might need speech marks ={"C"}