Can I increment a parameter in my expression?

I am calculating some columns and I need to increment a parameter by 1 for every new column, is that possible?
Like I create a parameter with date 01/01/2017 and in my calc. I just do
(xy - {date]+1)
(xy - {date]+2)
(xy - {date]+3)

and so on…

It sounds like you’re performing some calculations in a matrix table. Usually, it’s better to perform calculations when the data is presented as a straight table, and only pivot it into a matrix table as the last step. If it was a straight table then incrementing the parameter would be done by rows which is as simple as adding a row number (e.g. generated by Enumerate transformation).

Incrementing by columns is not possible at this moment.

1 Like

I am not very familiar with EasyMorph yet but I am learning :slight_smile:
Can you show me what would be the best way calculating columns for each month with a calculaton like this

if(not isempty([Project / Service Start Date]) and not isempty([Project / Service End Date]),
if(makedate(2017, 2, 1) >= [Project / Service Start Date] and makedate(2017, 2, 1) <= [Project / Service End Date], [FTE], 0),
if(isempty([Project / Service Start Date]) and isempty([Project / Service End Date]), 0,
if(isempty([Project / Service Start Date]) and makedate(2017, 2, 1) <= [Project / Service End Date], [FTE], 0)))

the logic behind this is less relevant but the makedate() part, I have 12 Columns with the same calculation and I have to replace the month value for each… this is frustrating =)

Can I do this with a helper table or something similar?

Thanks in advance.

Look at the example below. It multiplies the column number by 100 and adds a random value from column [Data]. I’ve added annotations for each step that explain the logic behind.

Book1.xlsx (9.1 KB)
Matrix calculations.morph (3.1 KB)

2 Likes