ew

EW (End week) is a time adjustment that is used to include all data that has been registered in a week.

The day that is used as End of week varies from country to country, and which day the week ends on is determined by the server settings. So if the server setting for EW is Saturday and you wish to use Sunday as EW, enter EW+1D.

Syntax

[node,bop,eop+ew]

Use

Use this function to retrieve data where cutoff is the end of the week. If you have a daily scorecard frequency and want to show values for the last week write:

[node1,bop+bw,eop+ew]

This formula will fetch all data that is registered in [node1] from the beginning to the end of the current week.

The formula [node1] will only return values for one day, if the period is Day.

EW can also be used with other time adjusting functions.

Version 5.1.2.0

This document contains confidential information. Not to be copied by third parties without written authorization.