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
Syndicate_Admin's avatar
Syndicate_Admin
Icon for Administrator rankAdministrator
4 years ago

Thank you for the help, it works.

Is it possible to define the date in the code as a variable so that I do not have to write this out?

--> In case I need to change the date, I would only have to do this in the variable and not in every line.

For example

000114.jpg

Samarth_18's avatar
Samarth_18
Icon for Community Champion rankCommunity Champion
4 years ago

Syndicate_Admin Okay try this then:-

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

if(Tabelle2[category] = "küche"&& Tabelle2[Shipment]  > _yr_2021&& Tabelle2[Shipment] < _yr_2022, 0.25 * 200,

IF( [category] = "küche" && [IBN]  > _yr_2021 && [IBN] < _yr_2022, 0.5 * 200,

if(Tabelle2[category] = "küche"&& Tabelle2[Ready]  > _yr_2021&& Tabelle2[Ready] < _yr_2022, 0.5 * 200,

if(Tabelle2[category] = "Bad"&& Tabelle2[Order]  > _yr_2021&& Tabelle2[Order] < _yr_2022, 0 * 200,

if(Tabelle2[category] = "Bad"&& Tabelle2[Shipment]  > _yr_2021&& Tabelle2[Shipment] < _yr_2022, 0.25 * 200,

if(Tabelle2[category] = "Bad"&& Tabelle2[IBN]  > _yr_2021&& Tabelle2[IBN] < _yr_2022, 0.5 * 200,

if(Tabelle2[category] = "Bad"&& Tabelle2[Ready]  > _yr_2021&& Tabelle2[Ready] < _yr_2022, 0.5 * 200