margin flagging

[jadams123]

Hi

Can some one help me with this formula:

ITEM_NO	Sales	Margin	if((column(3) > 0),'Y','N')
ORI	$1,067,241.25	$417,707.08	Y
ZZ	$393,263.33	$393,263.33	Y
TSF	$946,720.60	$343,977.14	Y
GLU	$1,211,490.97	$337,970.18	Y
GLU	$1,029,243.72	$281,447.37	Y
TER	$37,228.43	($18,822.36)	Y
INB	$4,921.72	($18,998.05)	Y
OSE	$40,847.47	($21,705.15)	Y

I am trying to do:

if margin is negative then Y else if N.

[sunny_talwar]

I am guessing that ITEM_NO is a dimension here? May be use Column(2) instead of Column(3)

If(Column(2) > 0, 'Y', 'N')

[rupamjyotidas · Accepted solution]

to avoid confusion maybe

if([Margin]>0,'Y','N')