Formula

Hi-Experts,

I Have a requirement for that I need your help.

Module name: Summery module

Dimension in the module - Time, Category, Product, customer

I wanna move to all products(except fruits) sales data to one customer(AR Channel).

Fruits data move to another channel(FR Channel).

IF ITEM(Customer) = Customer.AR Channel then Sales upload.Total ELSE IF ITEM(Customer) = Customer.FR Channel THEN Sales upload.Total[LOOKUP: PRODUCT. Fruits] ELSE 0

But this formula was not working. How to move to some sales data to one channel and another portion of data to another channel.

Please help me with this

Regards,

Mahesh

Accepted answers

rob_marshall

@sandeep_bk @UMAMAHESH @Niranth ,

Ideally, you don't want to hardcode any formula using the "if Item(list) = List.Member" as this is bad practice (Planual rule 2.02-12). Instead, think about creating a "calculation" module that gets the data, then use a Line Item Subset (dimenionalizes the line items), create a mapping module of the line items in the line item subset to the the list members (Channels), and then do a sum of the data.

Hope this helps,

Rob

All comments

Niranth

Hi Mahesh,

Try using this formula,

IF ITEM(Customer) = Customer.AR Channel then Sales upload.Total - Sales upload.Total[select:PRODUCT. Fruits] ELSE IF ITEM(Customer) = Customer.FR Channel THEN Sales upload.Total[Select: PRODUCT. Fruits] ELSE 0

SandeepB

Hi Mahesh,

Try this way, this might help.

Create one filter line item in the same module/Filtered module with a boolean format which checks the category (In your case Fruits)

Once you have this, try your logic based on this boolean check.

For example :

Anaplan Community-2.PNG

Source module :

Anaplan Community-3.PNG

Let me know if you need any help on this.

Thanks,

Sandeep

rob_marshall

@sandeep_bk @UMAMAHESH @Niranth ,

Hope this helps,

Rob

Quick Links

Can you help?

Unanswered questions

Request for Workflow Design: End-User Report Finalization & Stakeholder Notification with Version Co
Hi everyone, I'm looking to design a workflow and would appreciate your input or guidance on how to set this up effectively in Anaplan. So, the goal is: Once end users complete their data input, they should be able to trigger a process that: Notifies stakeholders via email with a link to a report. The report includes: A…
OAUTH 2.0 vs Google Sheets Extension
Hi, My org is looking to explore leveraging Google Apps script to extract data out of Anaplan and update already built templates in Google Sheets. We use the Anaplan Extension currently but find it crashes often with the amount of tabs, data, etc. Has anyone used both Anaplan OAUTH 2.0 API and Goolge Apps Script to write…
Exports with anaplan using informatica connector
I'm trying to execute an Action to export data with the use of a Mapping in Informatica. But it gives us null rows .If we export directly from Anaplan , the export file has all the rows filled. Both exports have same number of rows but in the informatica export the values appear as blank. This issue is with only some…