UFN_KPICATALOG_GETDECIMALPLACES

Gets the number of decimal places to display for goal or KPI values for a given KPI.

Return

Return Type
tinyint

Parameters

Parameter	Parameter Type	Mode	Description
@KPICATALOGID	uniqueidentifier	IN

Definition

Copy



            create function dbo.UFN_KPICATALOG_GETDECIMALPLACES(@KPICATALOGID uniqueidentifier)
            returns tinyint
            as
            begin

                declare @RETURNVALUE tinyint;

                select @RETURNVALUE = DECIMALPLACES from dbo.KPICATALOG where ID = @KPICATALOGID;

                return @RETURNVALUE;

            end;