Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I have two tables namely Open and Filled in which i have Open Positions and Filled Positions data respectively.
Now i need to show, Number open Positions(Req Number) from min(OpenDate) to selected year and it should check for it is Filled or not in the same time span.
I used the following exp
=count ({<Open.Status={'Open'},[Open.Opened Date]={"<=$(Year) "},Filled.Status={"<>$('Filled')"}>}DISTINCT [Req Number])
Please look at Attached app
the correct answer is if you select 2013 it should show 1 and if you select 2014 it should show 29 if you select 2015 or nothing it should show 87
=count ({<Open.Status={'Open'},[Open.Opened Date]={"<=$(=Floor(YearEnd(MakeDate(Max(Year)))))"}>}DISTINCT [Req Number])
I remove the Filled.Status <> Filled (Filled.Status=-{Filled}) because all records are Filled
Yes but i need the Req numbers from Open Table which are not present in Filled Table.
how to achieve that??
Hi Nithin,
try solving the synthetic keys first in your app.
For Req numbers from Open Table which are not present in Filled Table :
Use Where not exists() condition.
I cannot reload the app here.
i want it expression level. because it should respond to the filter
Thats what. try resolving the synthetic key first. if you have syn keys theres a possibilty that your count may not be accurate.
After that post the app.
Thanks
you are asking me to remove synthetic keys?
yes. after that post the app.
PFA