Search Box is not working with Formula created in Prompts Section
I have created one Formula in Prompts section of my dashboard by concat two different DB columns "School_ID" & "School_Name" and kept the Formula name as "School_Details".
But when I'm searching with School_ID in Incorta search box, no result is coming. Then I went to Filter Section of dashboard and searched directly in "School_Details" filter the result is available for same School_ID.
Could you please help me on this, why this problem is happening & the their solution?
Thanks in advance.