0

How do I write the code within the formula?

Choose.ninox

I want to create a formula in the Orders table that displays "AAAAA" when only Warehouse A is selected in Inventory; displays "BBBBB" when only Warehouse B is selected; and displays "AAABBB" if both Warehouse A and Warehouse B are selected. How do I write the code within the formula?

2 replies

null
    • red_kite
    • 9 mths ago
    • Reported - view

    And what ist the result for Warehouse A, B, C? Ok. Try this. Mirko

    let result := unique(sort(Inventory.text(Warehouse)));
let A := item(result, 0);
let B := item(result, 1);
let C := item(result, 2);
switch true do
case cnt(result) = 1:
    A + A + A + A + A + A
case cnt(result) = 2:
    A + A + A + B + B + B
case cnt(result) = 3:
    A + A + B + B + C + C
default:
    join(result, "")
end
      • gold_cat
      • 9 mths ago
      • Reported - view

       thanks friend

Login to reply

Content aside

  • Status Answered
  • 9 mths agoLast active
  • 2Replies
  • 39Views
  • 2 Following