Why don't you try IF(column_name IS NULL, 0) AS column_name;
After this you can perform your aggregation on top of this.
On Wed, Jun 3, 2015 at 11:16 AM, Ravisankar Mani wrote:
> Hi Everyone,
>
> I need to check condition measure value is null or not. If it is null is
> then replace 0 otherwis
Hi Everyone,
I need to check condition measure value is null or not. If it is null is
then replace 0 otherwise in returns same values
It is a sample sql query
SELECT ISNULL(SUM(CAST([Purchasing].[Vendor].[BusinessEntityID] AS
decimal(38,6))),0)
AS [BusinessEntityID],
[Purchasing].[Vendor].[Ac
