line item total in another column

pdekas

Hello guys,

pretty sure the solution must be simple but i cannot find it.

I am trying to use the total of a line item in another formula.

what i have looks like the screenshot

Thanks in advance 🙂

Accepted answers

All comments

KirillKuznetsov

@pdekas use:

formula Amount without VAT[SELECT:All months]

remove time dimension from Sum line item

pdekas

ive already tried the SELECT function, doesnt work in my case.
''The name All Months used in the SELECT clause is not recognized as a list member or version in the model''

KirillKuznetsov

@pdekas

Just to check: Is your month list a built-in time scale or a custom month list?

If it is a custom, then you need to write [SELECT:{name of your list}.All Months]

ChrisAHeathcote

Try selecting the top level item directly from opening the list in model settings.

anirudh

Can you post a screenshot of the list you have created

Quick Links

Can you help?

Unanswered questions

Azure SQL Connection, database name with Hyphens in Data Orchestrator
I am attempting to connect to an azure SQL database vis at the MSSQL connector in data orchestrator but am having issues and I believe it is due to hyphens in database name (which is a fairly standard naming convention I will note!) Example below (fake credentials) - has anyone else encountered similar and is there a way…
12.4.1 Activity: Create Saved View for Non Employee Expenses
Hi, for some reason my shipping costs are the same over every month and I don't know what to do to fix it.
Workaround for Formula & Closing Balance summary methods together in Polaris
Hello folks, Does anyone know how to work around the Polaris limitation of using the Formula or Ratio summary method alongside the Closing Balance within the same line item? I have a Business Unit list where the total (All BUs) must display the Corporate (1 of 20 leaf items under All BUs total) number of Unique Customers.…