SAC- DATA ACTION TRIGGER - ERASE VALUES

[former_member675985]

Hi fellow community,

I wanted to see If any of you could help me with this situation...

I´m trying to use the template of SAC BUSINESS CONTENT - LIQUIDITY PLANNING

There´s a Data Action to calculate the opening and closing balance of each date that you define,

the thing is that if I don´t make any modifications to the data, If I only leave it as I imported It and want to make the opening/closing calculations, It gives me a blank result for all the account members.

CONFIG.TIME_HIERARCHY = CALENDARYEAR
CONFIG.FLIPPING_SIGN_ACCORDING_ACCTYPE = OFF
CONFIG.GENERATE_UNBOOKED_DATA = ON
MEMBERSET [d/Date] =BASEMEMBER([d/Date].[h/YWD], %TargetDate%)
MEMBERSET[d/CURRENCY]=%Currency%
MEMBERSET[d/BANK_ACCOUNT]=%BankAccount%
MEMBERSET[d/AUDIT_TRAIL]="SAC"
MEMBERSET[d/COMPANY_CODE]=%CompCode%

FOREACH [d/Date]
	//Clear target before loading
	DATA([d/LIQUIDITY_ACCOUNT] = "1000000000_Opening") = 
        RESULTLOOKUP([d/LIQUIDITY_ACCOUNT] = "4000000000_Closing", [d/Date] = PREVIOUS())
    DATA([d/LIQUIDITY_ACCOUNT]= "4000000000_Closing") = 0
	
	//Include the base level liquidity items
	IF [d/LIQUIDITY_ACCOUNT].[p/Include] = ("X") THEN
		
		DATA([d/LIQUIDITY_ACCOUNT] =  "4000000000_Closing") = RESULTLOOKUP()
		
	ENDIF
	
ENDFOR

I was wondering If there's any solution to this problem.

[Sujit]

Not clear with your requirement ask, could you please elaborate more on it ?