Percentage Functions %XT and %YT in Input-Ready Queries (New)

In the context of BW Integrated Planning, you can use new formulas in input-ready queries to scale to the result.

The new formulas do not relate to the grand total however (like %GT does). They relate to the next total level on the X or Y axis instead:

  • %XT (Scale to Result Along the Columns)
  • %XT (Scale to Result Along the Rows)

With regard to input-readiness, the same rules apply as for %GT. It is not necessary to create an inverse formula.