Page tree
Skip to end of metadata
Go to start of metadata

Summary

Merge periods

Example: ...

Situation

...

Settings...
Result

...

Project-File...

Want to learn more?

 Settings

Merge periods

Columns of input table


ParameterValueOpt.DescriptionExample
From

System.Object

-Where do the time periods begin?-
To

System.Object

-Where do the time periods end?-

Parameter


ParameterValueOpt.DescriptionExample
Target area

System.String

  • Day
  • Week
  • 4 weeks
  • Month
  • 13 weeks
  • Quarter
  • 52 weeks
  • Year
-Where will this be mapped?-
Delete old

System.Boolean

-Delete the old time intervals?-
Virtual start date for n-weeks, quarters, years

System.DateTime

opt.For weeks, quarters and year / 365 days: start from where?-
Year type

System.String

  • 365 days
  • Normal year (29.2 in input will be ignored!)
  • Leap year
opt.For year: which type?-

 Examples

Example 1: ...

...

Calculation methodSettingsResult
... 

 

 Troubleshooting
ProblemFrequent CauseSolutions
The week starts with Sunday instead of Monday - in the WEEK use

Development language in the editor is English (and there
the default week starts on Sunday. 

As it is a week it is not ifluenced by the start of the year date

 Add a Formua operator with the following code:

#From help#.DayOfYear == 1 ? XIH.SetDateTime("From help", #From help#.AddDays(7)) && XIH.SetDateTime("Until help", #Until help#.AddDays(7)) : true 


Or for the wekly perspective:

XIH.SetDateTime("Until help", #Until help#.AddDays(((int) #From help#.DayOfWeek) == 6 ? 8 : 1)) &&
XIH.SetDateTime("From help", #From help#.AddDays(((int) #From help#.DayOfWeek) == 6 ? 8 : 1)) &&
XIH.SetString("Start", (#Start#).Replace("As from week","").Replace("Mo","").Replace("Su","")) ?

Related topics

  • ...