Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

multiple conditions + calculation

Hi Community,   following problem. My calculation with multiple conditions including addition does not work       Here is my formula that doesn't work:    If(and( Category ="Küche" && Order ...
Need Help
Tips and Tricks
Samarth_18's avatar
Samarth_18
Community Champion
4 years ago

@Olboss_384 , Please try this:-

 

 

 

Column = 
if(Tabelle2[category] = "küche"&& Tabelle2[Order]  > DATE ( 2021, 12, 31 )&& Tabelle2[Order] < DATE ( 2022, 12, 31 ), 0 * 200,

if(Tabelle2[category] = "küche"&& Tabelle2[Shipment]  > DATE ( 2021, 12, 31 )&& Tabelle2[Shipment] < DATE ( 2022, 12, 31 ), 0.25 * 200,

IF( [category] = "küche" && [IBN]  > DATE ( 2021, 12, 31 ) && [IBN] < DATE ( 2022, 12, 31 ), 0.5 * 200,

if(Tabelle2[category] = "küche"&& Tabelle2[Ready]  > DATE ( 2021, 12, 31 )&& Tabelle2[Ready] < DATE ( 2022, 12, 31 ), 0.5 * 200,

if(Tabelle2[category] = "Bad"&& Tabelle2[Order]  > DATE ( 2021, 12, 31 )&& Tabelle2[Order] < DATE ( 2022, 12, 31 ), 0 * 200,

if(Tabelle2[category] = "Bad"&& Tabelle2[Shipment]  > DATE ( 2021, 12, 31 )&& Tabelle2[Shipment] < DATE ( 2022, 12, 31 ), 0.25 * 200,

if(Tabelle2[category] = "Bad"&& Tabelle2[IBN]  > DATE ( 2021, 12, 31 )&& Tabelle2[IBN] < DATE ( 2022, 12, 31 ), 0.5 * 200,

if(Tabelle2[category] = "Bad"&& Tabelle2[Ready]  > DATE ( 2021, 12, 31 )&& Tabelle2[Ready] < DATE ( 2022, 12, 31 ), 0.5 * 200

))))))))

 

 

 

Departure:-

 

Thank you

Samarth