How do I get the lowest value of all the years?

Hello,

I need help in getting the lowest value of all the years. see screenshot below :

I need to get the value -1,249,884 since that is the lowest

Thanks

Accepted answers

Hi,

Add a line item - Lowest value across all Periods:

Add a formula: Timesum(Sourcemodule.lineitem, , , MIN)

source module.lineitem - the data across FY23 thru FY29

MIN will return the value -1,249,884

Set the Timescale summary to min and reference that using select All periods.

3.3.12 Activity: Create Product Replenishment UX Page
Kindly assist me with the below lines. What i need to do first after creating the UX sheet. How to add Product SKU and Time context selectors in the Page. Include the following: Product SKU and Time context selectors. SYS00 Time Settings by Month module, Planning Period Filter for UX saved view (or create a custom view…
How to represent in Anaplan an organizational structure
Hi, is it possible to use a Network Card in order to show an organizational structure which cannot be managed through Hierarchy Lists, cause there are branches that don't have the same hierarchy levels associated? Example: In a L1 COMPANY > L2 AREA > L3 SERVICE > L4 OFFICE There is a case like this: COMPANY A AREA A…
ADO Certification - Cannot Create Migration Link
Hi - I cannot seem to create a migration for Assignment 3 and it will not allow me to update the hierarchy and proceed further. It seems to think that a link has already been created, but I don't see anything. Any ideas?