[font="Verdana"]Are we talking a SQL Server T-SQL formula, or a SQL Server Analysis Services MDX formula, or a SQL Server Reporting Services inline formula or a VB.Net formula or an Excel formula or a Crystal Reports formula or...
Also, what have you already tried? What is your definition for the value you want?
[/font]