Formula

Options
UMAMAHESH
UMAMAHESH Member, ALL USERS, Community Member Posts: 5 Contributor
in Planning & Modeling

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

 

 

Tagged:

Categories