To obtain data from each row of a Datamart (DM), use:
UserEntry("fieldName") and StringUserEntry("fieldName")
After running the logic in a Data Load, as it iterates through each row of the Target DM, it
will automatically access the Field Name parameter within the UserEntry("fieldName") formula.
This field value can then be used in the rest of the logic.
To add data to a field with calculation logic, give an element in your logic the same name as
the target field in the DM and whatever is returned in that element will be inputted into that field
in the DM when the logic is run.
To run the logic, create a new Data Load by hitting the 'Add' button and give it the same name
as the target DM with the type 'Calculation'. Go to the 'Target' tab and select a target DM
from the drop down menu. You can filter the DM here so the logic will only be run on certain
rows of the DM.
Go to the 'Calculation' tab and select your formula from the drop down menu.
You will see your inputs in the 'Formula Fixed Inputs' column. To test the formula, select a DM
row in the 'Target' tab and click 'Test Formula' in the 'Calculation' tab. You will see the results in
'Formula Outputs' and 'Row Result' columns. You can click the save button to store your filter
on the DM and your formula. Click 'Run Now' to run the logic on the target DM.