TM1 Forum

['price']=N: 
  IF( ['amount'] < DB('Discounts','1',!Suppliers,!Materials,'To')
       ,
       DB('Discounts','1',!Suppliers,!Materials,'Price')
       ,
       IF( ['amount'] < DB('Discounts','2',!Suppliers,!Materials,'To')
            ,
            DB('Discounts','2',!Suppliers,!Materials,'Price')
            ,
            IF( ['amount'] < DB('Discounts','3',!Suppliers,!Materials,'To')
                 ,
                 DB('Discounts','3',!Suppliers,!Materials,'Price')
                 ,
                 DB('Discounts','4',!Suppliers,!Materials,'Price')
            )
       )
  ) ;

Antrac1t wrote:Hello,
I have some problems with select value from the interval through two cubes.
1, cube (Discounts) contains these dimensions: Intervals and Intervals metric (in context are Suppliers and Materials)

2, cube (Amount selection) contains these dimensions: Materials and Materials metric (in context are only Suppliers)


Now i want that when i will write some amount one material. Then I want obtain the price from a given interval, where the quantity is. This is a discount system.
For this problem i used this IF:
['price']=IF((DB('Discounts',!Intervals,!Suppliers,!Materials,'from')<['amount'])&(DB('Discounts',!Intervals,!Suppliers,!Materials,'to')<['amount'])<['amount']),DB('Discounts',!Intervals,!Suppliers,!Materials,'Price'),0);
(this rule is written in a cube "Amount selection")

Unfortunately it does not work but I think it should: D.

All this is done in the Performance modeler and Architect (10.1.1)

Thx for help guys.