Skip to Content
0
Former Member
Nov 05, 2012 at 05:46 PM

restrict key figure for total

31 Views

Hi Experts

I create a query based on 0TCT_MC23,acctually I want get the total records last 30days. So I creat a restrict key figure RKF_TOL_RES_30 based on 0TCTRECORDD and variant 0DAT range (from -30 to 0) . But I got the result like below table, seems Records Last 48H is ok but can't get the total number records last 30 days. Could you give hits on it? Thx a lots.

InfoPackageID

0TCTIFPAKID

RequestID

0TCTREQSID

Records Last 48H

0TCT_MC23_RK204

with 0I_48CTS

Records Last 30Days

RKF_TOL_RES_30D

0TCTRECORD

with variant 0DAT range(-30 - 0)

Records

0TCTRECORDS

A 111111 1 1 222222 2 2 333333 3 3 3