How to increment a variable while Iterating a "table" in ER (Electronic Reporting)

(0) Share

Report

Posted on by Daniele.Selvi

160

Hi All,

I am struggling to find a way (either using a data type that I am not aware of, or doing a workaround) to increment a variable while exporting a "list of transactions" to Excel, using ER.

What I want to do is the following, but I cannot find a good way of calculating the value of the cell "Progressivo"(incremental amount):

In X++ I would simply do:

Progressivo = Progressivo + (Debit-Credit)

but it seems I cannot sue the same kind of sintax in the ER formula:

Hope my example is clear enough.

Many Thanks,

I have the same question (0)

All responses (7)

Answers (0)

Ludwig Reinhard Microsoft Employee on at

Like (1)

Report

RE: How to increment a variable while Iterating a "table" in ER (Electronic Reporting)

Hi,

One possibility I can think of is doing this in the excel template - not in the ER.

If you add an additional Excel calculation that adds the current line value plus the previous line value you should end up with the total at the end.

I am not an excel expert though and you might have to do some testing whether this works out.

Best regards,

Ludwig

Was this reply helpful? Yes No
Daniele.Selvi 160 on at

Like (0)

Report

RE: How to increment a variable while Iterating a "table" in ER (Electronic Reporting)

Hi Ludwig,

it might be useful doing it in the excel template however the position of the Excel lines are not always consecutive(I simplified the example) but I could have populated line 7, line 15, line 22, etc.... as I might have something in between.

Are you aware of a way to "declare" a variable that can "store" a value each iteration ?

Thanks for the prompt reply.

Was this reply helpful? Yes No
Daniele.Selvi 160 on at

Like (0)

Report

RE: How to increment a variable while Iterating a "table" in ER (Electronic Reporting)

I have created a Macro to resolve my issue and actually the file is working fine. However (very sadly) it is not possible to attach a file with a macro(with extension xlsm):

do you know any "workaround" to add an excel file with a Macro on it ?

thanks

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

RE: How to increment a variable while Iterating a "table" in ER (Electronic Reporting)

Hi Daniele, were you able to attach a .xlsm file successfully?

Was this reply helpful? Yes No
Daniele.Selvi 160 on at

Like (0)

Report

RE: How to increment a variable while Iterating a "table" in ER (Electronic Reporting)

nope....ER won't allow you to add a file with Macros....its a shame as you could quite many pretty good things :)

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

RE: How to increment a variable while Iterating a "table" in ER (Electronic Reporting)

Amen. Cheers Daniele.

Was this reply helpful? Yes No
Guillermo Irusta 15 on at

Like (0)

Report

RE: How to increment a variable while Iterating a "table" in ER (Electronic Reporting)

Hi, i have the same problem in a report that i want to create.

Did you find a way to solve it? I know this is an old topic

Was this reply helpful? Yes No