Hi,
is it possible to create a script that will automatically create an arrangement of layers for the amount column of my dataset?
By the way... this forum is an awesome idea!
SREN
Offline
Last seen: 11 years 5 months ago
Joined: 10/25/2012 - 04:22
Hi SREN and welcome to the site.
I am glad you are enjoying the site. As a long time IDEA user it is something that I have always felt was missing. I am hoping that this site will eventually fill the void and become a great source for the all types of IDEA users.
I am not sure what you mean by an "arrangement of layers", are you talking about the grouping function in IDEA or something else.
Thanks for your quick answer. I see the site has just started. This forum is a great idea, since it seems hard to find good information on the topic on the web.
Yes, I meant the grouping function (just wasn't sure about the translation from German to English). We just implemented IDEA and are trying to automate some of our audit procedures.
Have you ever created a script that allows for automated grouping of the amount column? So far I could not figure out how to make a script for a grouping and still be able to click on the groups.
I would like to create a script that will immediatly group all the amount according to our internal financial approval regulations to identify split bills or dubios accounting entries.
Hi Sren,
That is one of the reasons I started the site as there doesn't seem to be a general user web site to support IDEA and I thought it would be useful.
As far as I know there is no way to use grouping with IDEAScript, also right now I find grouping has limited use in IDEA as you can't save your groups but have to recreate them each time.
Just wondering if performing a summary would work for you. Can you do it just using IDEA right now? If so the history creates the script at the same time and then we can help clean it up to make it more generic. If you have any dummy data you can post it on the site so I can have an idea of what you are looking at and trying to do.
In general when I create a script I try to figure out how to do it in IDEA first, do it once then save the script that the history creates and make the script more generic so that I can use it on other files. Let me know if you can do something like that.
Thanks
Thanks for your answer,
I am saving the script from the history as well and add multiple scripts into a larger one at times.
Since there is probably no way of grouping with IDEAScript, I tried to use a summary.
I think a summary may not work over all of the amounts in the table as it would just show me 40.000 different values and there is no chance of grouping them. However, I used the task.criteria" Amount % 100=0" to get the smooth values that may occur in a fraud situation.
The 4,000 limit with the summarization is only if you indicate that you wish to create a result. If you don't click on this it will summarize all the records with no limits. There is also a script in the library that will look for rounded numbers: http://www.ideascripting.com/Mod-Calculation-Script it might help you out.