WORKING WITH TORNADO CHART FOR GENDER COUNT

[DGAL1]

Hello , help with a code for tornado chart  , its giving me negatives for one gender 

if([GENDER]='F',
Num(count(if(YEAR([TRANSACTION_DATE])=vCY AND COUNTRY='INDIA', ID))*-1),
Num(count(if(YEAR([TRANSACTION_DATE])=vCY AND COUNTRY='INDIA', ID)))
)

my graph is this

In addition , how do i color with own colors for F and M , the below is the code am using but its not workingif([GENDER]='F', '#000000','#C51633')

[Chanty4u]

Try this 

if([GENDER]='F',

   Num(count(if(YEAR([TRANSACTION_DATE])=vCY AND COUNTRY='INDIA', ID))),

   Num(count(if(YEAR([TRANSACTION_DATE])=vCY AND COUNTRY='INDIA', ID)))

For gender color 

if([GENDER]='F', RGB(0, 0, 0), RGB(197, 22, 51))

)