${(record.taxtotal/record.subtotal*100)}%
# suitescriptn
NSN
10/20/2023, 4:59 PM${(record.taxtotal/record.subtotal*100)}%
e
erictgrubaugh
10/20/2023, 7:24 PMWhat do you want
subtotalerictgrubaugh
10/20/2023, 7:25 PMRather, how do you want this to behave if there's no subtotal?
n
NSN
10/20/2023, 10:30 PMsubtotal will always be there. even if 0.
So if the subtotal is. zero, tax will always be zero.
So, its trying to calculate like this. (0/0)
NSN
10/20/2023, 10:31 PMI can. Put the iff condition there, but i think there is. some other shortcut/function , i can apply on like ISNULL()
e
erictgrubaugh
10/21/2023, 1:43 AMIs this in a script or in a template?
a
alien4u
10/21/2023, 4:28 PM${(record.taxtotal/NULLIF(record.subtotal,0)*100)}%
n
NSN
10/22/2023, 7:33 PMThanks you very much @alien4u . That worked !