Perzival Posted July 21, 2019 Report Share Posted July 21, 2019 I am thinking if it's possible to use join inside a calculated field. If it is, how? An example would be appreciated. Quote Link to comment Share on other sites More sharing options...
0 Harbinger Posted July 21, 2019 Report Share Posted July 21, 2019 It is, indeed. I have tried self join in a calculated field and it's working. Something like this. Quote Link to comment Share on other sites More sharing options...
0 Perzival Posted July 21, 2019 Author Report Share Posted July 21, 2019 5 minutes ago, Harbinger said: It is, indeed. I have tried self join in a calculated field and it's working. Something like this. Thanks for the reply, I'll try this. I have another question, are subqueries possible as well? Quote Link to comment Share on other sites More sharing options...
0 Harbinger Posted July 21, 2019 Report Share Posted July 21, 2019 2 minutes ago, Perzival said: Thanks for the reply, I'll try this. I have another question, are subqueries possible as well? Hello, I am not certain about that. I haven't needed a subquery before. If I have spare time, I'll test it out and get back to you. Quote Link to comment Share on other sites More sharing options...
0 Perzival Posted August 24, 2019 Author Report Share Posted August 24, 2019 Hello @Harbinger have you tested this out? Quote Link to comment Share on other sites More sharing options...
0 Harbinger Posted August 24, 2019 Report Share Posted August 24, 2019 Hi @Perzival, Subqueries are possible but limited to calculations in the DataPage level in my experience. Quote Link to comment Share on other sites More sharing options...
0 Perzival Posted August 24, 2019 Author Report Share Posted August 24, 2019 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 Quote Link to comment Share on other sites More sharing options...
0 Harbinger Posted August 24, 2019 Report Share Posted August 24, 2019 If this formula was working before, it must be the Agent First Advance field that is not compatible with the other fields involved. Check their Datatypes in your table to see if that is the case. Quote Link to comment Share on other sites More sharing options...
0 Perzival Posted August 24, 2019 Author Report Share Posted August 24, 2019 Oh what a rookie mistake. Thanks again mate! Quote Link to comment Share on other sites More sharing options...
Question
Perzival
I am thinking if it's possible to use join inside a calculated field. If it is, how?
An example would be appreciated.
Link to comment
Share on other sites
8 answers to this question
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.