Yield - Group Overview - Revision history

Stanley.songok at 09:36, 1 October 2025

2025-10-01T09:36:21Z

← Older revision		Revision as of 11:36, 1 October 2025
Line 184:		Line 184:

	)</pre>		)</pre>
	\|		\|This is a line chart that displays revenue (EUR) and Chargeable Weights by their respective months.
	\|}		\|}

2025-10-01T09:34:11Z

@@ Line 108: / Line 108: @@
 |-
 |5. '''Group Target and Target Yield by Month'''
-|Target Yield =
+|GroupTarget = 1.73
 <pre>SWITCH(
@@ Line 160: / Line 161: @@
     BLANK()
 )</pre>
+|
 |}

2025-10-01T09:24:39Z

@@ Line 103: / Line 103: @@
+    )
 )</pre>
+|
 |}

2025-10-01T09:14:04Z

@@ Line 77: / Line 77: @@
 |-
 |2. '''Monthly Figures'''
-|Total Revenue In euro =
+|Total Revenue =
 <pre>SUM('Combined Quatations Tables2'[Revenue In EURO]) </pre>
+|
 |}

2025-10-01T09:01:44Z

← Older revision		Revision as of 11:01, 1 October 2025
Line 78:		Line 78:
	\|2. '''Monthly Figures'''		\|2. '''Monthly Figures'''
	\|Total Revenue In euro =		\|Total Revenue In euro =
	<pre>SUM('Combined Quatations Tables2'[Revenue In EURO]) <pre/>
			<pre>SUM('Combined Quatations Tables2'[Revenue In EURO]) </pre>

	\|		\|
	\|}		\|}

2025-10-01T08:59:35Z

Calculations

← Older revision		Revision as of 10:59, 1 October 2025
Line 67:		Line 67:
	!Description		!Description
	\|-		\|-
	\|1. Total Yield And Group Target By Year		\|1. '''Total Yield And Group Target By Year'''
	\|GroupTarget = 1.73		\|GroupTarget = 1.73
	TotalYield =		TotalYield =
	<pre>IF ( AND ( [Chargeable Weight] > 0, [Total Revenue In euro] > 0 ), [Total Revenue In euro] / [Chargeable Weight] )</pre>		<pre>IF ( AND ( [Chargeable Weight] > 0, [Total Revenue In euro] > 0 ), [Total Revenue In euro] / [Chargeable Weight] )</pre>
			\|
			* '''Group Target''' – Estimated average yield target across all sites.

			* '''Total Yield''' – Calculated by dividing revenue by chargeable weight.
			\|-
			\|2. '''Monthly Figures'''
			\|Total Revenue In euro =
			<pre>SUM('Combined Quatations Tables2'[Revenue In EURO]) <pre/>
	\|		\|
	\|}		\|}

2025-10-01T08:45:31Z

Calculations

← Older revision		Revision as of 10:45, 1 October 2025
Line 67:		Line 67:
	!Description		!Description
	\|-		\|-
	\|		\|1. Total Yield And Group Target By Year
	\|		\|GroupTarget = 1.73
			TotalYield =
			<pre>IF ( AND ( [Chargeable Weight] > 0, [Total Revenue In euro] > 0 ), [Total Revenue In euro] / [Chargeable Weight] )</pre>
	\|		\|
	\|}		\|}

2025-10-01T08:40:33Z

Data Transformation Applied

@@ Line 40: / Line 40: @@
 !Transformations
 |-
+|
+* '''Formatting''' – Data is arranged into a consistent structure used across all report pages.
 |}

2025-10-01T08:24:16Z

Filters

@@ Line 9: / Line 9: @@
 !Description
 |-
+|'''Database'''
+|Select the reporting database.
 |}

2025-10-01T08:13:39Z

← Older revision		Revision as of 10:13, 1 October 2025
Line 1:		Line 1:

	== Summary ==		== Summary ==
	This ~~is for the~~ page ~~"Yield - Group Overview" page that~~ is a part of the ~~Yield,~~ Weight and Revenue GSA ~~Report~~.		This page is part of the Weight and Revenue GSA report. It provides a summary of weekly and monthly yield performance, group targets, and corresponding figures for revenue and weights.

	== Filters ==		== Filters ==