Annual Comparison of Revenues

Technical name: 0LSO_C01_Q0008

Use

This query compares the current year's revenue received by the training provider with that for the previous year. The query evaluates revenue per course group, where revenue is understood as course fees minus course costs. The total fees are regarded as course sales.

Free Characteristics

InfoObject

Description

0TRAINTYPE

Course type

0TRAINTYPOTYP

Object type of course type

0TRAINING

Course

0TRAINOTYPE

Object type of course

0TRAINFORM

Delivery method

0LEARNERTYP

Object type of learner

0LEARNER

Learner

Rows

InfoObject

Description of the InfoObject (and Restriction or Calculation Formula)

0TRAINGROUP

Course group

Columns

InfoObject

Description of the InfoObject (and Restriction or Calculation Formula)

0LSO_C01_QT001

Comparison previous year/current year

0LSO_C01_CK006

Revenues

0LSO_C01_CK002

Total fees

0BOOKINGFEE

Attendance or participation fee

0CANCELFEE

Cancellation fee

0TRAININGCOSTS

Course costs