Yield Week-On-Week - Revision history

Stanley.songok: /* Calculations */

2025-10-01T13:00:49Z

Calculations

@@ Line 76: / Line 76: @@
 )</pre>
+|Total Yield Site calculates yield for a site by dividing total revenue by chargeable weight (only when both values are greater than zero).
 |}

Stanley.songok: /* Calculations */

2025-10-01T12:54:07Z

Calculations

← Older revision		Revision as of 14:54, 1 October 2025
Line 67:		Line 67:
	!Description		!Description
	\|-		\|-
	\|		\|1. T'''otalYield by Week Number And HOS Entity'''
	\|		\|TotalYield =
			<pre>IF (

			AND ( [Chargeable Weight] > 0, [Total Revenue Site] > 0 ),

			[Total Revenue Site] / [Chargeable Weight]

			)</pre>
	\|		\|
	\|}		\|}

Stanley.songok: /* Data Transformation Applied */

2025-10-01T12:47:10Z

Data Transformation Applied

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

Stanley.songok: /* Filters */

2025-10-01T12:44:31Z

Filters

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

Stanley.songok: /* Summary */

2025-10-01T12:42:27Z

Summary

← Older revision		Revision as of 14:42, 1 October 2025
Line 1:		Line 1:

	== Summary ==		== Summary ==
	This ~~is for the page "~~Yield - Week-On-Week" page ~~that~~ is a part of the Yield, Weight and Revenue GSA ~~Report~~.		This Yield Week-on-Week page is part of the Yield, Weight, and Revenue GSA report. It displays Total Yield by week number across different entities.

	== Filters ==		== Filters ==

David.weller: Created page with " == Summary == This is for the page "Yield - Week-On-Week" page that is a part of the Yield, Weight and Revenue GSA Report. == Filters == {| class="wikitable" |+ !Filter !Description |- | | |} == Data Transformation Applied == {| class="wikitable" |+ !Query !Transformations |- | | |} == Calculations == {| class="wikitable" |+ !Columns !Calculation !Description |- | | | |}"

2025-09-30T10:19:18Z

Created page with " == Summary == This is for the page "Yield - Week-On-Week" page that is a part of the Yield, Weight and Revenue GSA Report. == Filters == {| class="wikitable" |+ !Filter !Description |- | | |} == Data Transformation Applied == {| class="wikitable" |+ !Query !Transformations |- | | |} == Calculations == {| class="wikitable" |+ !Columns !Calculation !Description |- | | | |}"

New page

== Summary ==
This is for the page "Yield - Week-On-Week" page that is a part of the Yield, Weight and Revenue GSA Report.

== Filters ==
{| class="wikitable"
|+
!Filter
!Description
|-
|
|
|}

== Data Transformation Applied ==
{| class="wikitable"
|+
!Query
!Transformations
|-
|
|
|}

== Calculations ==
{| class="wikitable"
|+
!Columns
!Calculation
!Description
|-
|
|
|
|}