Detail (W+M) - Revision history

Hendry.mwamburi: /* Calculations */

2025-11-26T12:01:12Z

Calculations

← Older revision		Revision as of 14:01, 26 November 2025
Line 177:		Line 177:
	),		),
	0)</pre>\|\| The formula calculates the gross profit in euros where either the booked timestamp or the confirmed timestamp is not null.		0)</pre>\|\| The formula calculates the gross profit in euros where either the booked timestamp or the confirmed timestamp is not null.
			\|-
			\| Total Chargeable Weights in kg \|\|<pre>Chargeable_Weight quoted kg =
			COALESCE(
			CALCULATE(
			SUM(Quotation[chargeable_weight_kg]),
			NOT ISBLANK(Quotation[quoted_at]),
			Quotation[type]=8),0)</pre>\|\| The formula calculates the total chargeable weight in kilograms
	\|-		\|-
	\| Total Margin in euros % \|\|<pre>Margin (%) =		\| Total Margin in euros % \|\|<pre>Margin (%) =

Hendry.mwamburi: /* Calculations */

2025-11-26T11:59:54Z

Calculations

← Older revision		Revision as of 13:59, 26 November 2025
Line 133:		Line 133:
	\|-		\|-
	! style="width: 20%;" \| Reference !! style="width: 40%;" \| Calculation !! style="width: 40%;" \| Description		! style="width: 20%;" \| Reference !! style="width: 40%;" \| Calculation !! style="width: 40%;" \| Description
	\|-
	~~\| Total Jobs \|\|<pre>Total Jobs=~~
	~~CALCULATE(~~
	~~DISTINCTCOUNT('Quotation'[id]),~~
	~~FILTER(~~
	~~'Quotation',~~
	~~NOT ISBLANK('Quotation'[id])~~
	)
	~~)</pre>\|\| The formula calculates the total number of unique jobs by quotation ID~~
	\|-		\|-
	\| Total Revenue in euros booked or confirmed \|\|<pre>Total Revenue (EUR Booked or Confirmed) =		\| Total Revenue in euros booked or confirmed \|\|<pre>Total Revenue (EUR Booked or Confirmed) =
Line 193:		Line 184:
	0		0
	) </pre>\|\| The formula calculates the total margin in euros where either the booked timestamp or the confirmed timestamp is not null.		) </pre>\|\| The formula calculates the total margin in euros where either the booked timestamp or the confirmed timestamp is not null.
	\|-
	~~\| Origin destination~~
	~~pair~~
	~~\|<pre> each [origin] & " - " & [destination]</pre>\|\| The formula concatenate origin column and destination column~~

	\|}		\|}

Hendry.mwamburi: /* Calculations */

2025-11-26T11:59:10Z

Calculations

@@ Line 133: / Line 133: @@
 |-
 ! style="width: 20%;" | Reference  !! style="width: 40%;" | Calculation  !! style="width: 40%;" | Description
+|-
 |-
 | Total Revenue in euros booked or confirmed ||<pre>Total Revenue (EUR Booked or Confirmed) =
@@ Line 178: / Line 186: @@
      ),
 )</pre>|| The formula calculates the gross profit in euros where either the booked timestamp or the confirmed timestamp is not null.
 |-
 | Total Margin in euros % ||<pre>Margin (%) =
@@ Line 190: / Line 192: @@
      [Total Revenue (EUR Booked or Confirmed)],
 ) </pre>|| The formula calculates the total margin in euros where either the booked timestamp or the confirmed timestamp is not null.

Hendry.mwamburi: /* Calculations */

2025-11-26T11:57:02Z

Calculations

← Older revision		Revision as of 13:57, 26 November 2025
Line 178:		Line 178:
	),		),
	0)</pre>\|\| The formula calculates the gross profit in euros where either the booked timestamp or the confirmed timestamp is not null.		0)</pre>\|\| The formula calculates the gross profit in euros where either the booked timestamp or the confirmed timestamp is not null.

	\|-		\|-
	\| Total Chargeable Weights in kg \|\|<pre>Chargeable_Weight quoted kg =		\| Total Chargeable Weights in kg \|\|<pre>Chargeable_Weight quoted kg =

Hendry.mwamburi: /* Calculations */

2025-11-26T11:52:52Z

Calculations

← Older revision		Revision as of 13:52, 26 November 2025
Line 185:		Line 185:
	SUM(Quotation[chargeable_weight_kg]),		SUM(Quotation[chargeable_weight_kg]),
	NOT ISBLANK(Quotation[quoted_at]),		NOT ISBLANK(Quotation[quoted_at]),
	\|-
	~~\| Origin destination~~
	~~pair~~
	~~\|<pre> each [origin] & " - " & [destination]</pre>\|\| The formula concatenate origin column and destination column~~

	\|}
	\|-		\|-
	\| Total Margin in euros % \|\|<pre>Margin (%) =		\| Total Margin in euros % \|\|<pre>Margin (%) =

Hendry.mwamburi: /* Calculations */

2025-11-26T11:52:03Z

Calculations

← Older revision		Revision as of 13:52, 26 November 2025
Line 191:		Line 191:

	\|}		\|}
			\|-
			\| Total Margin in euros % \|\|<pre>Margin (%) =
			DIVIDE(
			[Total Revenue (EUR Booked or Confirmed)] - [Total Cost (EUR booked or confirmed)],
			[Total Revenue (EUR Booked or Confirmed)],
			0
			) </pre>\|\| The formula calculates the total margin in euros where either the booked timestamp or the confirmed timestamp is not null.

Hendry.mwamburi: /* Calculations */

2025-11-26T11:50:33Z

Calculations

← Older revision		Revision as of 13:50, 26 November 2025
Line 184:		Line 184:
	CALCULATE(		CALCULATE(
	SUM(Quotation[chargeable_weight_kg]),		SUM(Quotation[chargeable_weight_kg]),
	NOT ISBLANK(Quotation[quoted_at]),		NOT ISBLANK(Quotation[quoted_at]),
	\|-
	~~\| Total Margin in euros % \|\|<pre>Margin (%) =~~
	~~DIVIDE(~~
	~~[Total Revenue (EUR Booked or Confirmed)] - [Total Cost (EUR booked or confirmed)],~~
	~~[Total Revenue (EUR Booked or Confirmed)],~~
	0
	~~) </pre>\|\| The formula calculates the total margin in euros where either the booked timestamp or the confirmed timestamp is not null.~~
	\|-		\|-
	\| Origin destination		\| Origin destination

Hendry.mwamburi: /* Calculations */

2025-11-26T11:48:48Z

Calculations

← Older revision		Revision as of 13:48, 26 November 2025
Line 178:		Line 178:
	),		),
	0)</pre>\|\| The formula calculates the gross profit in euros where either the booked timestamp or the confirmed timestamp is not null.		0)</pre>\|\| The formula calculates the gross profit in euros where either the booked timestamp or the confirmed timestamp is not null.

	\|-		\|-
	\| Total ~~Cost~~ in ~~euros~~ \|\|<pre>~~Total Cost (EUR booked or confirmed)~~ =		\| Total Chargeable Weights in kg \|\|<pre>Chargeable_Weight quoted kg =
	~~SUMX~~(		COALESCE(
	~~FILTER~~(		CALCULATE(
	~~'Dimreporting_db quotation_totals',~~		SUM(Quotation[chargeable_weight_kg]),
	~~'Dimreporting_db quotation_totals'[created_at] >= DATE(2024, 1, 1)~~		NOT ISBLANK(Quotation[quoted_at]),
	),
	~~SWITCH(~~
	~~TRUE~~(),
	~~NOT ISBLANK('Dimreporting_db quotation_totals'~~[~~booked_at~~]),
	~~'Dimreporting_db quotation_totals'[customer_invoice_currency_cost_total]~~
	~~/ 'Dimreporting_db quotation_totals'[booked_customer_invoice_currency_to_euro_exchange_rate],~~
	~~ISBLANK('Dimreporting_db quotation_totals'[booked_at])~~
	&& NOT ISBLANK(~~'Dimreporting_db quotation_totals'~~[~~confirmed_at~~]),
	~~'Dimreporting_db quotation_totals'[customer_invoice_currency_cost_total]~~
	~~/ 'Dimreporting_db quotation_totals'[confirmed_customer_invoice_currency_to_euro_exchange_rate],~~
	0
	)
	~~)</pre>\|\| The formula calculates the total cost in euros where either the booked timestamp or the confirmed timestamp is not null.~~
	\|-		\|-
	\| Total Margin in euros % \|\|<pre>Margin (%) =		\| Total Margin in euros % \|\|<pre>Margin (%) =

Hendry.mwamburi: /* Calculations */

2025-11-26T11:46:14Z

Calculations

@@ Line 133: / Line 133: @@
 |-
 ! style="width: 20%;" | Reference  !! style="width: 40%;" | Calculation  !! style="width: 40%;" | Description
 |-
 | Total Revenue in euros booked or confirmed ||<pre>Total Revenue (EUR Booked or Confirmed) =

Hendry.mwamburi: /* Calculations */

2025-11-26T11:45:17Z

Calculations

@@ Line 142: / Line 142: @@
+     )
 )</pre>|| The formula calculates the total number of unique jobs by quotation ID
-|-
 |-
 | Total Chargeable Weights in kg ||<pre>Chargeable_Weight quoted kg =