Good evening, I'm trying to recreate a balance but it depends of some previous values, theres any way to get a value from the previous record with IDEAScript (i know there's a GetPreviousValue in the EquationEditor).
I will appreciate your help.
Thank you.
aamparo
Offline
Last seen: 4 years 2 months ago
Joined: 08/11/2013 - 19:15
Yes there is but it means reading each record one by one and can get complicated depending on what you are doing. Depending on what it is I would try the GetPreviousValue function first before going the script route, if you do need to do it by script can you give more detail so I can help you out more.
Hi Brian,
I have the same problem as aamparo...
Say, I have field like this:
1
0
0
2
0
3
0
and I want to create a new field where records with "0" value get a previous value that not "0".
GetPreviousValue function gives me just one record above.
Is there any way to do this with IdeaScript?
Thank you.
Brian, thank you very much, I spend a lot of time searching for solution.
What I didn't know, it's that I can enable updating through script. It's actually gives me solution for several other scripts too.
Glad to help, doing it this way can sometimes be frustrating as the documentation isn't the best and lots of time you have to try different things before it actually works. Hopefully the above will help you out.
Hello,
I'm trying to read data from a IMD file using syntax similar to the above rec.getNumvalue but for a string- [rec.getStringValue("FieldName")]. Each time I do this, howver, i get the error "Object does not support this property or method."
I have no problems reading a numeric value with the getNumValue function, but can't seem to read a string. Any thoughts?
Hello Lloyd, try rec.getCharValue("FieldName") and see if that fixes the problem.
Brian
Hello, I'm trying to come with two different balances after performing some computations as follows:
1. At the Beginning I have got two balances ie. Internal and external
2. The opening balance of the external balance is zero at the beginning (is to be affected by any forex movements)
3. The Internal balance is to be affected by any local transactions movement
4. When some1 receives forex it has to increase the forex balance and when some1 makes a a forex it has deplete the forex balance. In a scenario where some1 wants to make a forex expenditure and the forex balance is zero ...his or her account should be reduced by the expenditure figure ite -10
5.If some1 wants to make local transaction he/she uses the internal account balance, however if the internal doesnt have sufficient funds , the remainder amount should be deducted fom the external balance
my objective is to come up with a closing balance for each customer account (internal and external)
I have attached an excel file as an exmple.I will appreciate your help.
Hello Binwel and welcome to the site.
Thanks for the spreadsheet. Can you redo the spreadsheet and show me what information you have available and what output you are expecting. I am assuming that you would also have a customer number and such for this? Also it you could include a couple of customers that would be good, it makes it easier to understand what you are looking for.
Thanks
Brian
Pages