Help with Multi Formular Expression

[karlo4711]

Hey everyone,

I'm new to Alteryx and writing expressions in general. Here's the problem I need your help with:

I want to output the result of the following expression into field with column "Backlog prog. FP" and the row with the same datatype entry "Backlog prog. FP".

All my Row "coordinates" are counted from the OUTPUT fields.

The calculation for the output I want to make goes something like: 

IF [COLUMN "Backlog FP" ROW-3 (upper RecordID 2)] IS NOT NULL

THEN OUTPUT = VALUE FROM COLUMN "Backlog FP" ROW-3 (upper RecordID 2)

ELSE [COLUMN "Backlog prog. FP" ROW-5 (upper RecordID 5 / Number from last month)] + [COLUMN "1st. conf. (open)" ROW-4 (upper RecordID 1)] - [COLUMN "last conf. (open)" ROW-3 (upper RecordID 2)] - [COLUMN "Delivered" ROW-2 (upper RecordID 3)]

I know this is tough, just for clarity here would be the calculations:

OUTPUT 1 = 4638 

OUTPUT 2 = 4402 (4638 [OUTPUT 1] + 338 [1st. conf. (open)] - 574 [last conf. (open)] - NULL [Delivered])

Does this make any sense to you? 😅

I would appreciate any help, because I'm completely overwhelmed....

Thank you 🙏

Tim

[karlo4711]

Push