Number format

[srikanth1994]

Hi Qlik learners,

Actual number is below one means full number but user want to see only two numbers as attached below please help me to how we can do this .

1400000.006						0
100000.0016		601573.7649	-601573.7649			-601573.7649
		-210552.2522	210552.2522		394.6091769	210157.643
		126168.2237	-126168.2237	129985.5269	129985.5269	-256153.7506
		339219.951	-339219.951	60919.31129	61120.45475	-400340.4058
		167700.9633	-167700.9633	53380.72198	54885.46327	-222586.4266
		-12059538.85	12059538.85	-45959.73169	-44910.73162	12104449.58
1500000.008		-11035428.2	11035428.2	198325.8285	201475.3225	10833952.88

Jan-22	Feb-22	Mar-22	Apr-22	May-22	Jun-22	Jul-22	Aug-22	Sep-22	Oct-22	Nov-22	Dec-22
1.4	0.1
	0.6	(0.2)	0.1	0.3	0.2	(12.1)
	(0.6)	0.2	(0.1)	(0.3)	(0.2)	12.1
			0.1	0.1	0.1	(0.0)
		0.0	0.1	0.1	0.1	(0.0)
-	(0.6)	0.2	(0.3)	(0.4)	(0.2)	12.1	-	-	-	-	-

[JordyWegman]

Hi Srikanth,

Depending if you only want X.X values in the millions then use:

if(Fabs( Sum(Number) )>1E6
    , num(Sum(Number)/1E6,'#,0;(#,0)')
    , null()
)

If you want to expand, also show other values in X.X. Then extend the null() with the same IF statement but change the 1E6 to 1E3 or 1E9.

Jordy

Climber