Hello there
I have two columns : Start Date and End Date for each transaction in my workflow. And there were multiple transaction units as well. I wanted to add a column that entails each date between those two dates and named it as continuous dates. It created a new column and added multiple rows, one for each date between the start date and the end date. I used the following syntax on the multi row formula:
Initialization Expression
Start Date
Condition Expression
Date < [End Date] + DateTimeAdd([Date],+1,'days')
Loop Expression
DateTimeAdd([Date],+1,'days')
Now the challenge is that for each transaction, the first date of one becomes the last date for the previous one, and hence that date is being counted twice and appearing twice in the continuous date column. And since i have grouped by another value (Bin), it is happening multiple times.
Any insight on how I can get an output, where if one date within each Bin is the first date for a particular transaction, it is not considered as the last bin for another.
I have attached the workflow. It is a little robust. But then the relevant part is command 84 onwards
Thanks! I am amidst an internship and any help would be great !
