% of Orders Basket Varietals (Excl $0) CP
Formula
m₁ / m₂
with:
m₁ = Distinct Count([Order Items].[Order Eid])
WHERE
[Order Items].[Order Completed Date] ≥ 'Start of Current Period'
AND [Order Items].[Order Completed Date] ≤ 'End of Current Period'
AND [Order Items].[Is 0 Dollar Order] = false
m₂ = Distinct Count([Order Items].[Order Eid])
WHERE
[Order Items].[Order Completed Date] ≥ 'Start of Current Period'
AND [Order Items].[Order Completed Date] ≤ 'End of Current Period'
AND [Order Items].[Is 0 Dollar Order] = false
Additional Details
Output Format: ##0.0%
Created: 2024-09-12T15:21:11Z
Last Updated: 2024-10-10T14:37:15Z
Key:
[calculation].[% of Orders Basket Varietals (Excl $0) CP]
Tags
% of Orders Basket Varietals (Excl $0) CP
Completed Date
Is 0 Dollar Order
Order Eid
Varietal
