Jump to content
  • 0

Filtering Criteria using Calculated Field


QueenB

Question

5 answers to this question

Recommended Posts

  • 0

Hi @NailDyanC,

 

Thank you for your response. 

I have two tables, Student_Record and Student_Info. Both tables are linked together. Student_Record  contains Payment field. 

Per Student_ID, I want to sum all the payments that particular student made. If greater than 0, then the Status should be Active, else Inactive. 

Here is my formula:

CASE 
WHEN
(SELECT SUM(Payment) FROM Student_Record WHERE Student_ID = target.[@field:Student_ID] > 0 THEN
'Active'
ELSE
'Inactive'
END 

 

I have this in my calculated field. I want to use Status as my filtering criteria but it seems that it is not allowed.

 

Thanks.

Link to comment
Share on other sites

  • 0

Hi @IamBlossom,

I think using a select statement in the Formula field at the table is not possible because it's pre-define. 

What I suggest is you just add a field in the first table that you can use to store the data that your going to get in the second table using a trigger action, you can check the process in this video tutorial:

And then you can use the data that is transfered in your Formula field.

I hope this helps :)

~WatashiwaJin~

Link to comment
Share on other sites

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.

Guest
Answer this question...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...
×
×
  • Create New...