Monday, May 27, 2019

Show Image Size in Megabytes (MB) on a Document-type Saved Search

When creating a document saved search, users can show the image size in kilobytes (KB) by adding the Size (KB) field under the Results tab. There is no standard field to show the image size in Megabytes format. Users can add a Formula (Numeric) field and define a simple formula that will convert the value from kilobytes (KB) to megabytes (MB).

1. Navigate to Lists > Search > Saved Searches > New.
2. Select Document from the list.
3. Enter a Search Title.
4. Under the Results tab, add Formula (Numeric) under the Field column.
5. Click the formula icon under the formula column. A small Saved Document Search window will appear.
6. Click the dropdown arrow for the Field box.
7. Select Size (KB).

Note: Since we will be converting Kilobytes (KB) to Megabytes (MB), we have to multiply the value of this field by 0.000976562.
1 KB = 0.000976562 MB

E.g.
{documentsize} * 0.000976562

8. Click Set.
9. Click Save & Run.

Actual Result: A long set of numbers are displayed. E.g. 2.0035437816191400625

Users can set a function to round the results to the nearest hundredths. E.g. From 2.0035437816191400625 to 2.

10. From the results page, click Edit this Search.
11. Under the Results tab, set the Function column to Round to Hundredths.
12. Click Save & Run or Preview.

No comments:

Post a Comment