Hello, it is probably because [int]/[int]=[int] (behavior of the language), so if you expect the single value, you must retype some value to this datatype.The easiest way to do this is for example:
(ABS(wouldtrigger*1.000)/ABS(total)) as percentage
Please let me know if it helped.
Ah, perfect that does the trick.
and to make it look nice: ROUND((ABS(wouldtrigger*1.000)/ABS(total))*100,2) as percentage