line item total in another column

pdekas
Contributor

line item total in another column

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 🙂

pdekas_0-1631630571475.png

 

5 REPLIES 5
KirillKuznetsov
Certified Master Anaplanner

Re: line item total in another column

@pdekas  use:

formula Amount without VAT[SELECT:All months]

OR

remove time dimension from Sum line item

pdekas
Contributor

Re: line item total in another column

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
Certified Master Anaplanner

Re: line item total in another column

@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]

ChrisHeathcote
Community Boss

Re: line item total in another column

Try selecting the top level item directly from opening the list in model settings.
Chris Heathcote
Bedford Consulting

Gold Partner and Regional Partner of the Year 2021, EMEA
anirudh
Community Boss

Re: line item total in another column

Can you post a screenshot of the list you have created