Lookup Value

Helper V

2 years ago

Good evening,

I will give another table, maybe my example and requirements are not clear.

DS Table

Syntax,

Sample # 1

If "Year" (from DS Table) is equal to year column (calendar - assuming there is a calendar table and selected year is 2024

If "BU" (from DS Table) is equal to BU column (assuming there is a BU table, let say "3" is selected

Filter "KPI" from DS Table) = " "

Filter "Item" from DS Table = "B"

Result must be 18%

-------------------------------------------------

sample # 2

If "Year" (from DS Table) is equal to year column (calendar - assuming there is a calendar table and selected year is 2024

If "BU" (from DS Table) is equal to BU column (assuming there is a BU table, let say "3" is selected

Filter "KPI" from DS Table) = "Stretch"

Filter "Item" from DS Table = "G"

Result must be 6%

Regards,

Obet

Forum Discussion