I have managed to store each formula as a variable with the same name as the payment term in my data file. However I can't match the variable with my data field. Could someone please help with the syntax or other suggestion?
%InvID, [Document Date], PTCode, Date([Document Date]+1) asduda, //Example formula
$(PT01) as[Due Date 1], //Fixed variable works Evaluate('$(' & PTCode & ')') as[Due Date 2]//Getting correct variable from PTCode field does not work FROM Data source
Thank you Vineeth for the example. However I didn't manage to apply it to my case. I want all formulas to be used in one field "due date" not in a separate field for each formula. Besides I want to create further calculations based on due date which is why I want to calculate it in load.