How to Lock and Unlock Scaling
  • 1 Minute to read
  • Dark
    Light
  • PDF

How to Lock and Unlock Scaling

  • Dark
    Light
  • PDF

Article summary

To use scaling in a report, you must be logged into SpotlightXL and have user access to design reports.

The Scaling property in Report Design will lock or unlock based on the Save on Model property. For example, on the Report Design page (below) for the A_CompanyReport2 report, the Millions scaling Amount Format is applied and then saved.

ModelingImages451to500image1.png

When you run the report, data is displayed according to the Millions Amount Format (scaling) applied as shown below.

ModelingImages451to500image2.png

When you apply a scaling property to a report that has Save on Model enabled, the cells are locked from the input. In this case, the A_CompanyReport2 report has Save on Model enabled for the Budget Model so the cells will be locked to prevent input.

ModelingImages451to500image3.png

If Save on Model is not enabled, the report cells will unlocked to allow data input.


Was this article helpful?