cancel
Showing results for 
Search instead for 
Did you mean: 

ScripT lOGIC FOR MULTIPLING TWO ACCOUNTS

Former Member
0 Kudos
79

Hi All,

We need to multiply two accounts using SQL script logic.

Account3=Accoun1*Account2

Accoun1 : Units

Account2 :Price

Account 3:Total

In the above scenerio units will be inout by user through Input schudule,while value of Price will be loaded in account and will not change. and we need calculate Account3(Total) at RUN time.

So Please help me with the script logic code to ge used in default.lgf

View Entire Topic
i045436
Advisor
Advisor
0 Kudos

Hello,

*WHEN ACCOUNT

*IS u201CAccount1u201D

*REC(ACCOUNT=u201DAccount3u201D, FACTOR=GET(ACCOUNT=u201DAccount2u201D))

*ENDWHEN

Former Member
0 Kudos

we are using this code only , but in reports its not showing the value for account 3 rather it shows 0 for all values , where user is changed has input value for units "account1"

Former Member
0 Kudos

Hi,

If this logic is in default logic file then run the default package once from Data Manager.

regards,

Lokesh Nandula