Slider not working for limit >= 1000

[#1]

Hello Dears,

I have a flag on my tablebox with the below code to trigger the slider:

fabs(
Num#(if(IsNull(((Sum({$<Pivot_Item_Type={'SUBST'}>} QTY_STOCK))/ (Sum({$<Pivot_Item_Type={'SUBST'}>} DAILY_AVG_CURRENT_WEEK_OUT))))=-1, 0, (((Sum({$<Pivot_Item_Type={'SUBST'}>} QTY_STOCK))/ (Sum({$<Pivot_Item_Type={'SUBST'}>} DAILY_AVG_CURRENT_WEEK_OUT))))),'# ##0.0')>= Num#(v_IC_Prod_Min_Value,'# ##0.0') and Num#(if(IsNull(((Sum({$<Pivot_Item_Type={'SUBST'}>} QTY_STOCK))/ (Sum({$<Pivot_Item_Type={'SUBST'}>} DAILY_AVG_CURRENT_WEEK_OUT))))=-1, 0, (((Sum({$<Pivot_Item_Type={'SUBST'}>} QTY_STOCK))/ (Sum({$<Pivot_Item_Type={'SUBST'}>} DAILY_AVG_CURRENT_WEEK_OUT))))),'# ##0.0', '.')<= Num#(v_IC_Prod_Max_Value,'# ##0.0', '.')
)

I don't know maybe its the function  Num#(v_IC_Prod_Max_Value,'# ##0.0', '.')

the slider works well for values between 0 to 999. But does not work when the max value exceeds 999, that is for values >= 1000

DO you have any idea please how to correct?

THanks in advance

[#2]

Hi Manuel,

please find the expressions as follows:

ITEM CODE	ITEM NAME	TOTAL STOCK	TOTAL INVENTORY COVERAGE	Sum({$<Pivot_Item_Type={'SUBST'}>} QTY_STOCK)/ Sum({$<Pivot_Item_Type={'SUBST'}>} DAILY_AVG_CURRENT_WEEK_OUT)	Num#(v_IC_Prod_Max_Value,'# ##0.0')	Num#(v_IC_Prod_Min_Value,'# ##0.0')	Num#(if(IsNull(((Sum({$<Pivot_Item_Type={'SUBST'}>} QTY_STOCK))/ (Sum({$<Pivot_Item_Type={'SUBST'}>} DAILY_AVG_CURRENT_WEEK_OUT))))=-1, 0, (((Sum({$<Pivot_Item_Type={'SUBST'}>} QTY_STOCK))/ (Sum({$<Pivot_Item_Type={'SUBST'}>} DAILY_AVG_CURRENT_WEEK_OUT))))),'# ##0.0')	Num#(if(IsNull(((Sum({$<Pivot_Item_Type={'SUBST'}>} QTY_STOCK))/ (Sum({$<Pivot_Item_Type={'SUBST'}>} DAILY_AVG_CURRENT_WEEK_OUT))))=-1, 0, (((Sum({$<Pivot_Item_Type={'SUBST'}>} QTY_STOCK))/ (Sum({$<Pivot_Item_Type={'SUBST'}>} DAILY_AVG_CURRENT_WEEK_OUT))))),'# ##0.0')>= Num#(v_IC_Prod_Min_Value,'# ##0.0')	Num#(if(IsNull(((Sum({$<Pivot_Item_Type={'SUBST'}>} QTY_STOCK))/ (Sum({$<Pivot_Item_Type={'SUBST'}>} DAILY_AVG_CURRENT_WEEK_OUT))))=-1, 0, (((Sum({$<Pivot_Item_Type={'SUBST'}>} QTY_STOCK))/ (Sum({$<Pivot_Item_Type={'SUBST'}>} DAILY_AVG_CURRENT_WEEK_OUT))))),'# ##0.0')<= Num#(v_IC_Prod_Max_Value,'# ##0.0')
+01001900	0	-	-	-	1 214.4	75.2	0	0	-1
+01001901	0	-	-	-	1 214.4	75.2	0	0	-1
+01002000	0	-	-	-	1 214.4	75.2	0	0	-1
+01002001	0	-	-	-	1 214.4	75.2	0	0	-1
+01002300	0	-	-	-	1 214.4	75.2	0	0	-1
+01002301	0	-	-	-	1 214.4	75.2	0	0	-1
+01002302	0	-	-	-	1 214.4	75.2	0	0	-1
+01002400	0	-	-	-	1 214.4	75.2	0	0	-1
+01003000	0	-	-	-	1 214.4	75.2	0	0	-1
+01003001	0	-	-	-	1 214.4	75.2	0	0	-1
+01003101	0	-	-	-	1 214.4	75.2	0	0	-1
+01003102	0	-	-	-	1 214.4	75.2	0	0	-1
+01003300	0	-	-	-	1 214.4	75.2	0	0	-1
+01003802	0	-	-	-	1 214.4	75.2	0	0	-1
+01003900	0	0	0.0	18.71958068	1 214.4	75.2	18,719580681393	0	0
+01003901	0	0	0.0	21.57906248	1 214.4	75.2	21,579062477218	0	0
+01003902	0	-	-	-	1 214.4	75.2	0	0	-1
+01004200	0	0	0.0	16.93317604	1 214.4	75.2	16,933176042943	0	0
+01004400	0	0	0.0	20.1873385	1 214.4	75.2	20,187338501292	0	0
+01004500	0	0	0.0	80.47585724	1 214.4	75.2	80,475857242827	-1	0
+01106800	0	-	-	-	1 214.4	75.2	0	0	-1

[#3]

Header or expression is:

Num#(if(IsNull(((Sum({$<Pivot_Item_Type={'SUBST'}>} QTY_STOCK))/ (Sum({$<Pivot_Item_Type={'SUBST'}>} DAILY_AVG_CURRENT_WEEK_OUT))))=-1, 0, (((Sum({$<Pivot_Item_Type={'SUBST'}>} QTY_STOCK))/ (Sum({$<Pivot_Item_Type={'SUBST'}>} DAILY_AVG_CURRENT_WEEK_OUT))))),'# ##0.0')<= Num#(v_IC_Prod_Max_Value,'# ##0.0')

[Anonymous]

Hi Ashley,

One more question, if you put on slider 1010 works? and with 900.5?

Thanks!

[#5]

It works well for max values up to 999 as shown below:

But when I use value 1000 or 1010 (below screenshot), it not longer works. The condition below evaluates to 0 when in fact, it should have returned -1:

Num#(if(IsNull(((Sum({$<Pivot_Item_Type={'SUBST'}>} QTY_STOCK))/ (Sum({$<Pivot_Item_Type={'SUBST'}>} DAILY_AVG_CURRENT_WEEK_OUT))))=-1, 0, (((Sum({$<Pivot_Item_Type={'SUBST'}>} QTY_STOCK))/ (Sum({$<Pivot_Item_Type={'SUBST'}>} DAILY_AVG_CURRENT_WEEK_OUT))))),'# ##0.0')<= Num#(v_IC_Prod_Max_Value,'# ##0.0')

[Anonymous]

Hi Ashley,

I cannot reproduce your issue...

I think it could be the space between thousands and hundreds.

Num(Num#(if(IsNull(((Sum({$<Pivot_Item_Type={'SUBST'}>} QTY_STOCK))/ (Sum({$<Pivot_Item_Type={'SUBST'}>} DAILY_AVG_CURRENT_WEEK_OUT))))=-1, 0, (((Sum({$<Pivot_Item_Type={'SUBST'}>} QTY_STOCK))/ (Sum({$<Pivot_Item_Type={'SUBST'}>} DAILY_AVG_CURRENT_WEEK_OUT))))),'# ##0.0'),'###0.0')<= Num(Num#(v_IC_Prod_Max_Value,'# ##0.0'),'###0.0')

Regards!

[#7]

Thanks lots to Jonathan and Manuel for your help

I modified code for Flag expression as follows by replacing Num#( , '# ##0.0')  with num(round((, '0.1'), '# ##0.0','.') and it appears to be working all good :

fabs(
num(round((Sum({$} QTY_STOCK)) / (Sum({$} DAILY_AVG_CURRENT_WEEK_OUT)), '0.1'), '# ##0.0','.')>= num(round(v_IC_PoC_Min_Value, '0.1'), '# ##0.0','.') and num(round((Sum({$} QTY_STOCK)) / (Sum({$} DAILY_AVG_CURRENT_WEEK_OUT)), '0.1'), '# ##0.0','.')<= num(round(v_IC_PoC_Max_Value, '0.1'), '# ##0.0','.')
)