This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
Hi mate, does anyone can help me how to get rid or hide decimal if it
zero ?only show if the number was above 0.on image that i post, i have
Qty Column, can i hide the .0 number ?show only if the number was eg.
7.5 or 10.9 ?
Hi mate, can anyone help me to use about automation ?i was making
function that if i update any row, run automation to create file ?i got
this error bellow.The event and process of the 'Reports' Bot are not
compatible. The output of event 'On Update'...
Thanks Aurelien for your help.it help me for my case but it need a
little modification.Change Number([yourDecimal]) With
Decimal([yourDecimal]) And i use text virtual column.Eg :
IF(MOD([Qty],1)>0, [Qty], Decimal([Qty]) )
My view was different, i mean if there is no decimal, just show the
number without point decimal.eg: If number qty was 8.0 only show 8. if
6.2 show 6.2.If - Show6.0 - 610.0 - 1011.5 - 11.56.2 - 6.28.0 - 8