E:\Users\Komp\Downloads\June Report Update (1).xlsx|||`Data$`
False
1
June Report Update (1).xlsx
Query=`Data$`
Simple
IsNotNull
Report Month
2021-08-06 14:13:27
days
0
2021-08-06 14:13:27
2021-08-06 14:13:27
2021-08-06
fixed
True
!IsNull([Report Month])
False
False
"ReportType","INSTRUMENT_TYPE","Settlement Method","PostCategory","BAC_GL_ACCOUNT_NUM","MER_GL_ACCOUNT_NUM","EledgerAccountNo","Adjusted Expense 2021","Actual FIN28 Expense 2021"
False
False
True
False
False
False
False
False
False
upper
Simple
=
ReportType
True
fixed
2021-08-06 14:12:51
0
FA
2021-08-06 14:12:51
2021-08-06 14:12:51
[ReportType] = "FA"
Custom
Warning
All
ManualDelayed
#2
#1
INSTRUMENT_TYPE - Ascending
UniqueValue
RecordID
1
Int32
6
0
ByName
Warning
All
ManualDelayed
#1
#2
INSTRUMENT_TYPE = IF [Tile_SequenceNum]!=1 THEN null() ELSE [INSTRUMENT_TYPE] EN...
Custom
Warning
All
ManualDelayed
#2
#1
INSTRUMENT_TYPE - Ascending
UniqueValue
RecordID
1
Int32
6
0
ByName
Warning
All
ManualDelayed
#1
#2
INSTRUMENT_TYPE = IF [Tile_SequenceNum]!=1 THEN null() ELSE [INSTRUMENT_TYPE] EN...
Warning
All
ByPos
Simple
Contains
ReportType
True
fixed
2021-08-06 15:00:46
0
Total
2021-08-06 15:00:46
2021-08-06 15:00:46
Contains([ReportType],"Total")
Warning
All
ByName
#1
#2
Remove
Prefix
Mode_
Ignore
Horizontal
lisamccullough_KR_version