Hi, I would definetely split the line items, to make use of multi threading. ThanksArun

Scenario 1 - if only the name of the source model is changed. all import from source model will still work Scenario 2 - if the model ID is changed, then you need to re-map the models in "Source M...

Hi all, I would be really interested to hear your thoughts on the Cumulate function and how you have best utilised this without affecting performance? I understand on longer time ranges it is usu...

Hi Asha, Have a look at the below screenshots which perform the same functionality.a. Create  a "Qtr List"b. Create a property called "Qtr Date" in the Qtr List. This date specifies the star...

Hi atoh, We have had similar experiences, where excel sheets are more likely to crash after the add-in is installed.  One workaround is to turn the add-in off (via Excel Options -> Add-in...

Hello @Jsdeloria21 , Without complicating it much. The problem statement is filter the right transactions to import. Create few booleans on the source module to select the correct ...

An alternative approach is to build it up with multiple set commands:...set Operation=%Operation% -file "foo.txt" -get "D:\exported foo.txt"set Operation=%Operation% -file "bar.txt" -get "D:\exported ...

Hi @AshaPatil  There are multiple ways to achieve this and a great method posted by @ArunManickam You will need to need have an identifier against each of the quarter list ite...

Hey @AnyaS thanks for sharing!  Would it be possible to share the blue print view and formulas? this would help us to see more in detail how the method works. I agree with&nbs...

Hey Anya, I would like to know the methodology you have used to do the What-if Analysis. I had a similar situation in my project which I achieved via Import actions. First, I would import the inp...