Absolute values (ABS)

[Former Member]

Post Author: ivanl

CA Forum: Formula

Hi,

I have a field "type" that has positive and negative values. How do I ensure that the absolute value is extracted from database?

Thanks,

Ivan

[Former Member]

Post Author: ivanl

CA Forum: Formula

thanks for the reply.

Would this work?

if {table.field 1} = "max"

then abs ({table.field 2})

table field 2 is the $ value of associated products (account types) in table field 1.