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

@pdekas  use:

formula Amount without VAT[SELECT:All months]

OR

remove time dimension from Sum line item

Regards, Kirill Kuznetsov
Advanced, LLC
pdekas
Contributor

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

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

Regards, Kirill Kuznetsov
Advanced, LLC
ChrisAHeathcote
Community Boss

Try selecting the top level item directly from opening the list in model settings.
Chris
HeathcoteAndHerran.com
anirudh
Community Boss

Can you post a screenshot of the list you have created