my data action has no error , but it is not working ,

[divyansh-soni1]

I want to update my buying price column or br product with 100 but  data action is not working


CONFIG.HIERARCHY.INCLUDE_MEMBERS_NOT_IN_HIERARCHY = [d/Br_profit_center], [d/BR_Product], [d/BR_COMPONENT]

CONFIG.TIME_HIERARCHY = CALENDARYEAR

CONFIG.GENERATE_UNBOOKED_DATA = ON

CONFIG.FLIPPING_SIGN_ACCORDING_ACCTYPE = OFF

MEMBERSET [d/Br_profit_center] = BASEMEMBER([d/Br_profit_center], %profit_center%)  //MEMBERSET [d/Date] = %BUDGET_YR% TO NEXT(11, "MONTH", %BUDGET_YR%)

MEMBERSET [d/Date] = [d/Version].[p/start_date] TO [d/Version].[p/end_date]

MEMBERSET [d/gl_account1] = ("CIF LKR", "CIF_LKR")

MEMBERSET [d/BR_brand] = "#"

//MEMBERSET [d/BR_COMPONENT] = "#"

MEMBERSET [d/BR_SALES_OFFICE] = "#"

MEMBERSET [d/BR_SALES_ORG] = "#"

MEMBERSET [d/BR_customer] = "#"

MEMBERSET [d/BR_Dist_Channel] = "#"

//MEMBERSET [d/BR_SALES_ORG] = "#"

MEMBERSET[d/BR_CIF] = "CIF-USD"

IF [d/Br_profit_center] = BASEMEMBER([d/Br_profit_center].[h/heirarchy], "0PHAH") THEN

//IF [d/BR_Product].[p/] = "Imported Product" THEN

        DELETE()

DATA([d/gl_account1] = "Buying Price", [d/BR_CIF] = "CIF-USD" ) = RESULTLOOKUP([d/gl_account1] = "FOB" ) * ( 1 + (RESULTLOOKUP([d/gl_account1] = "INSURANCE %")/100) + (RESULTLOOKUP([d/gl_account1] ="FREIGHT")/100))

DATA([d/BR_Product] = "3000000368") = 1000

ENDIF

i tried this one also 

CONFIG.HIERARCHY.INCLUDE_MEMBERS_NOT_IN_HIERARCHY = [d/Br_profit_center], [d/BR_Product]

CONFIG.TIME_HIERARCHY = CALENDARYEAR

CONFIG.GENERATE_UNBOOKED_DATA = ON

CONFIG.FLIPPING_SIGN_ACCORDING_ACCTYPE = OFF

MEMBERSET [d/Br_profit_center] = BASEMEMBER([d/Br_profit_center], "0PHAH")   //MEMBERSET [d/Date] = %BUDGET_YR% TO NEXT(11, "MONTH", %BUDGET_YR%)

MEMBERSET [d/Date] = [d/Version].[p/start_date] TO [d/Version].[p/end_date]

MEMBERSET [d/gl_account1] = ("CIF LKR", "CIF_LKR")

MEMBERSET [d/BR_brand] = "#" //MEMBERSET [d/BR_COMPONENT] = "#"

MEMBERSET [d/BR_SALES_OFFICE] = "#"

MEMBERSET [d/BR_SALES_ORG] = "#"

MEMBERSET [d/BR_customer] = "#"

MEMBERSET [d/BR_Dist_Channel] = "#" //MEMBERSET [d/BR_SALES_ORG] = "#"

MEMBERSET[d/BR_CIF] = "CIF-USD"

//MEMBERSET[d/BR_COMPONENT] = "#"

IF [d/Br_profit_center] = BASEMEMBER([d/Br_profit_center].[h/heirarchy], "0PHAH") THEN

IF [d/BR_Product].[p/import_mnfr] = "Imported Product" THEN

DELETE()

/

DATA([d/gl_account1] = "Buying Price", [d/BR_CIF] = "CIF-USD" ) = 100

//DATA([d/gl_account1] = "Buying Price",[d/BR_Product] = "3000000368") = 1000*1

ENDIF

ENDIF

[William_Yu1]

Please also explain what you are trying to achieve with this piece of code.

[divyansh-soni1 · Accepted solution]

I was missing some profit center data, in my br_product now it is working fine 

but that calculation part is showing different result as expected like it is adding things 12 times