...
Stakeholders
Author
Subject matter expert(s)
Alex Goldberg
Data source(s)
eiboxoffice.dbo
TicketGroup
Event
Venue
Region
STG.users
PricerEvents
Users
Presentation Medium
SSRS
Fields (data)
Pricer
eName
VenueName
edate
SeatSection
TotalSale
GrossMargin
gmp
gsold
spi
cpi
gmpi
Data source(s)
The data gathered in this report is from the Eibo-215 Database and the STG Database. Using the stored procedure sr_GetSalesAndProfitability.
eiboxoffice.dbo
TicketGroup
Event
Venue
Region
STG.users
PricerEvents
Users
Calculations
Column Name | Data Type | Calculation | Description |
|---|---|---|---|
gmp | decimal | =CASE WHEN SUM(ISNULL(cte.gsale,0)) = 0 THEN -1 ELSE ROUND(((SUM(ISNULL(cte.gsale,0))+0.0001-SUM(ISNULL(cte.gcost,0))+0.0001))/(SUM(ISNULL(cte.gsale,0))+0.0001),2) END gmp, | Calculates gross margin percentage |
spi | decimal | =CASE WHEN SUM(ISNULL(cte.gsale,0)) = 0 THEN -1 ELSE ROUND((SUM(ISNULL(cte.gsale,0))+0.0001)/(SUM(ISNULL(cte.invct,0))+0.0001),2) END spi, | Calculates average sale per invoice |
cpi | decimal | =ROUND((SUM(ISNULL(cte.gcost,0))+0.0001)/(SUM(ISNULL(cte.invct,0))+0.0001),2) cpi, | calculates average cost per invoice |
gmpi | decimal | =CASE WHEN SUM(ISNULL(cte.gsale,0)) = 0 THEN -1 ELSE ROUND((((SUM(ISNULL(cte.gsale,0))+0.0001)/(SUM(ISNULL(cte.invct,0))+0.0001))-(SUM(ISNULL(cte.gcost,0))/(SUM(ISNULL(cte.invct,0))+0.0001)))/((SUM(ISNULL(cte.gsale,0))/SUM(ISNULL(cte.invct,0)))+0.0001),2) END gmpi | calculates average margin per invoice |
...
Change Log
Jira Legacy server System JIRAJira serverId ae03e0b8-3550-377d-ac32-70749cecd411 key SP-257
...