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
maybe
=count ( {$<[Req Number]=P(
{
<Open.Status={Open},[Open.Opened Date]={"<=$(=floor(yearend(makedate(max(Year)))))"}>
-
<Filled.Status={Filled}>
}
[Req Number])>} DISTINCT [Req Number])
It didnt worked like want we want want...
Hy Nithin, you removed the syn key but u forgot to associate the tables.
complete the data modelling first.
Thanks