Need help in Formula

Hi, guys!

I'm doing a logical formula in my module that says if a Unit (Line Item) is classified as Current (List: Sales Type) then it will perform a certain calculation otherwise if it is Non Current (List: Sales Type) then it will display zero. Can you please recommend me a formula for this?

Note: I have uploaded the data directly to the same module where I am doing the formula.

Thanks for the help!

Best.

Jerome

Accepted answers

All comments

PaulRitner

Hello,

Sounds like you will be doing some type of lookup to determine Current/Non-Current based on the value in the Unit Line Item.

I don't have the full facts, but it could be that Current/Non-Current is an attribute of Unit... and so you might do the following as either part of the overall formula, or in a separate line item:

UnitList.SalesType[Lookup: UnitLineItem] ...where UnitList is the list that the Unit line Item is formatted to

If this doesn't help, post a little more detail.

Cheers!

Paul

Quick Links

Can you help?

Unanswered questions

Azure blob connection Cloudworks vs ADO
I am trying to connect to Azure blob, the credentials work on cloudworks, but do not work on ADO. Has anyone else experienced this issue?
Berapa nomor Tokopedia?
Tokopedia Menyediakan layanan WhatsApp? Untuk menghubungi layanan Tokopedia melalui (WA)62_08174_9080_16 kamu bisa mengikuti.
Looking for Anaplan End-Users to take a short survey!
We are looking for Anaplan end-users to provide feedback on their experiences with the Excel add-in. Interested individuals will respond to this 5-minute survey to help us understand personal needs and behavior when using the add-in. The feedback provided by survey takers is essential to the roadmap of Anaplan's products.…