I have a formula field and i want the output to be this
( 3 @ 96 )
I am using a formula field with this code
If (table.No_of_Cables) Then
"(" & Truncate(Table.No_of_Cables) & " @ " & Truncate( table.totalLength / table.No_of_Cables) & ")"
my result is this : (3.00 @ 96.00) i need to remove the zeros. I tried the Truncate function, the Round function, and also the Int function
what am i doing wrong???