Sum of Variable Name Field

[Anonymous]

I need to make a sum of one field that have the name according to the month.

In attached one example.

I tried to use three diferent types of variables, but I don't know how to make the system understand that it is a field and not a string.

Can anyone help me?

Thanks

[kaushiknsolanki · Accepted solution]

Hi,

     Have a look at the application.

     Hope this is what you want.

Regards,

Kaushik Solanki

[Anonymous]

Hi Kaushik!

It is exactly that!

Thank you so much!

Regards,

Debora

[rustyfishbones]

Hi,

In Variable $(ROT1) you have written =Month(MonthStart(Today(), -2))

But there is no Date field in the Excel Spreadsheet and you have no Calendar created in the Script.

So I don't believe these Variables will Work.

Try changing the variables to the following

$(ROT1) as =SUM(ROT1)

$(ROT2) as =SUM(ROT2)

Then try the Expression sum_var like this =$(ROT1) + $(ROT2) and check if you get the correct result.

You will need to format COLUMN C and COLUMN F in the Excel spreadsheet as Numbers and RELOAD the Data

Hope this helps

Alan