Hi folks, ;D ;D
I have a the following in my Framework Model and it is producing a 1 or 0 for each record that meets the condition.
if ( [UCM Physical View].[STATUS] in (1,2,3) )
then (1)
else (0)
The problem is I need to have any record that falls into (1,2,3) to have only one row as 1 and not 3 rows showing 3 1's.
ID STATUS COUNT
1111 1 1
1111 2 1
1111 3 3
In the other word, I need to have the following to show as one count when the (1,2,3) is met as the condition.
ID STATUS COUNT
Pls help if you can.
Thanks so much. :) :)
111 1 1
1901 1111 2 1
1902 1111 3 3
Or if there is a way to handle this count within the Report Studio since I'm dropping it as a measure in the Report Studio Crosstab as a Defined Cell.
:) :)
Hi,
Will maximum status for ID work at the reportstudio or in FM? Also try a running-count as a filter and maximum status for ID as a filter.
Good luck
New guy
I setup the Determinant in FM Model Subject Query for ID, Status, and Date. So, it seems like it's doing the trick.
Thanks,