Hi All,
May I know how to convert negative value (-) to 0 ?
Below is my sample query:
dim finaltotalbonus as double
dim Sumtotalbonus as double
dim totaldeductamount as double
finaltotalbonus = Math.Round(Sumtotalbonus - totaldeductamount)
FinalTotal = finaltotalbonus
sample data :
finaltotalbonus = Math.Round(200 - 500)
FinalTotal = -300
How to make system show FinalTotal = 0 for negative value (-)?
Thanks, please help.