Expression Doubt

[rohitians]

Hello,

IF((GLAcc_Code=31027501 OR GLAcc_Code=31027503 OR GLAcc_Code = 31027504 OR GLAcc_Code = 31027506) AND (Div_Code>2010 AND Div_Code<2999),'Regulated Market'
,IF((GLAcc_Code=31027501 OR GLAcc_Code=31027503 OR GLAcc_Code = 31027504 OR GLAcc_Code = 31027506) AND (Div_Code>3000 AND Div_Code<3999),'Semi Regulated Market'
,IF((GLAcc_Code=31011002 OR GLAcc_Code=31026999),'API Domestics'
,IF((GLAcc_Code=31027502 OR GLAcc_Code=31027505),'API Exports',
))))

Here i have calculated dimension as above but i want to introduce total of regulated and semi regulated in this as well and API DOM and API Exports as well..

I am attaching the excel file for better understanding,

Thanks and Regards,

Rohit

[m_woolf]

I suggest that you load this logic in your script something like this:

IF((GLAcc_Code=31027501 OR GLAcc_Code=31027503 OR GLAcc_Code = 31027504 ORGLAcc_Code = 31027506) AND (Div_Code>2010 AND Div_Code<2999),'Regulated Market'
,IF((GLAcc_Code=31027501 OR GLAcc_Code=31027503 OR GLAcc_Code = 31027504OR GLAcc_Code = 31027506) AND (Div_Code>3000 AND Div_Code<3999),'Semi Regulated Market'
,IF((GLAcc_Code=31011002 OR GLAcc_Code=31026999),'API Domestics'
,IF((GLAcc_Code=31027502 OR GLAcc_Code=31027505),'API Exports',
)))) as NewField;