I see. Thanks mate. I also wanted to ask, I recently had an issue with one of my formula from the table. All other formula fields have been working fine. This only started happening when I added the "Agent First Advance" field.
Here's the formula:
CASE WHEN [@field:Agent_LOA_Advance_Type] is null OR [@field:Product] != 'MAPD' AND [@field:Product] != 'PDP' THEN ([@field:Premium]*[@field:Agent_Advance_Amount])*[@field:Agent_Commission_Percentage] END