Hi
I'm trying to do a very simple comparison but couldn't think of an efficient tool to do it.
As an example, if [Items] = WEATHER01, [value] <= 25, then [Conditions agree] = yes.
Below is sample output expected.
Items | Value | Conditions agree? |
WEATHER01 | 20 | Yes |
Thank you in advance
Solved! Go to Solution.
Hi @Luke_C
What if i have a multiple items? should I add same formula by using the (+) button in the formula tools? or you have better ideas?
Hi @alkafalhas
I would suggest implementing something like @Emil_Kos suggested, a mapping table for items and their thresholds.
Hi @alkafalhas,
The mapping table is always easier to maintain in a long run. So if possible I would almost always suggest using mapping tables instead of the formula tool.
Hi @Emil_Kos
Thank you for helping so far.
If I have a multiple items with different conditions, how can i address it?
Example below:
Items | Value | Conditions | Output |
WEATHER01 | 20 | Yes, if value<=20 | yes |
WEATHER02 | 20 | Yes, if value<=10 | No |
WEATHER03 | 40 | Yes, if value<=40 | Yes |