1
00:00:00,989 --> 00:00:05,809
level access twenty thirty two two rooms in the studio honored continuing mini

2
00:00:05,809 --> 00:00:07,819
series on invoices

3
00:00:07,820 --> 00:00:10,150
assist to going to be

4
00:00:10,150 --> 00:00:13,079
talk to you about some calculated fields

5
00:00:13,079 --> 00:00:16,849
outside to play along for the link below video to the time of such a website and

6
00:00:16,849 --> 00:00:19,329
download act twenty thirty

7
00:00:19,329 --> 00:00:22,310
t_v_ forty six

8
00:00:22,309 --> 00:00:28,588
nakano

9
00:00:28,588 --> 00:00:31,459
love interest so it's

10
00:00:31,460 --> 00:00:33,300
polls sportswear

11
00:00:33,299 --> 00:00:34,789
history

12
00:00:34,789 --> 00:00:36,719
okey dokey

13
00:00:36,719 --> 00:00:39,129
we're looking to do

14
00:00:39,130 --> 00:00:39,920
haste

15
00:00:39,920 --> 00:00:41,160
and create

16
00:00:41,159 --> 00:00:42,679
a

17
00:00:42,679 --> 00:00:44,729
datasheet four

18
00:00:44,729 --> 00:00:46,570
invoices

19
00:00:46,570 --> 00:00:48,149
um...

20
00:00:48,149 --> 00:00:49,699
remain dedicated to look

21
00:00:49,700 --> 00:00:51,750
fashion towards copy

22
00:00:51,750 --> 00:00:55,030
uh... serving my in this world

23
00:00:55,030 --> 00:00:56,558
placed that model

24
00:00:56,558 --> 00:00:58,709
make the main form

25
00:00:58,710 --> 00:01:00,380
white house invoices

26
00:01:00,380 --> 00:01:03,330
into if we take

27
00:01:03,329 --> 00:01:07,289
prompt former abs form casts many

28
00:01:07,290 --> 00:01:09,300
pretext for connects

29
00:01:09,299 --> 00:01:12,569
patrols control

30
00:01:12,569 --> 00:01:16,359
change its form invoices i will be looking at

31
00:01:16,359 --> 00:01:19,769
captured soldiers at the start of the video

32
00:01:19,769 --> 00:01:25,640
in a second website form invoice is

33
00:01:25,640 --> 00:01:29,719
chinese herbs invoices

34
00:01:29,719 --> 00:01:30,969
and

35
00:01:30,969 --> 00:01:32,310
worthy

36
00:01:32,310 --> 00:01:37,259
or leave this place using before trained divorces dietitian anyway

37
00:01:37,259 --> 00:01:40,150
uh... support formatting

38
00:01:40,150 --> 00:01:41,780
well business has dropped

39
00:01:41,780 --> 00:01:44,460
perform abortions in there

40
00:01:44,459 --> 00:01:50,679
for port to six

41
00:01:50,680 --> 00:01:52,820
part so

42
00:01:52,819 --> 00:01:57,439
embedded form invoices entry into nato an actual patients for invoices

43
00:01:57,439 --> 00:02:01,929
soviets credo socially guna craig query

44
00:02:01,930 --> 00:02:03,500
and the

45
00:02:03,500 --> 00:02:06,079
this is where we're gonna stop

46
00:02:06,079 --> 00:02:08,069
uh... i calculated fields

47
00:02:08,069 --> 00:02:10,318
and it's kab reasonably

48
00:02:10,318 --> 00:02:12,619
involves query

49
00:02:12,620 --> 00:02:13,959
let's start with

50
00:02:13,959 --> 00:02:16,539
uh... table invoices

51
00:02:16,538 --> 00:02:21,088
storybook who were some of the working on a t_v_ eighty discount

52
00:02:21,088 --> 00:02:23,508
mckinnon needs

53
00:02:23,508 --> 00:02:25,358
table

54
00:02:25,359 --> 00:02:27,409
bookings

55
00:02:27,408 --> 00:02:29,808
cousin invoices rates of booking we've got a

56
00:02:29,808 --> 00:02:31,378
get started

57
00:02:31,378 --> 00:02:35,929
toughing hurt safer now sorrow let's start with

58
00:02:35,929 --> 00:02:37,870
invoice ninety

59
00:02:37,870 --> 00:02:39,039
chest artie

60
00:02:39,038 --> 00:02:41,358
dat current discount

61
00:02:41,359 --> 00:02:43,808
let's take a look at it

62
00:02:43,808 --> 00:02:48,019
professor gordon bush league estonia dat and discount

63
00:02:48,019 --> 00:02:52,519
discounts experts the sand

64
00:02:52,519 --> 00:02:55,799
the shutdown

65
00:02:55,799 --> 00:02:57,979
chris dot blot eh... arch

66
00:02:57,979 --> 00:03:00,319
think who designed the

67
00:03:00,318 --> 00:03:01,659
goto

68
00:03:01,659 --> 00:03:06,658
table invoices that let's change

69
00:03:06,658 --> 00:03:08,008
discount

70
00:03:08,008 --> 00:03:10,978
cushions probably

71
00:03:10,979 --> 00:03:13,219
now former percent

72
00:03:13,218 --> 00:03:16,558
i think you away from former sentence maki

73
00:03:16,558 --> 00:03:22,769
general number optic fulmer ferre who objected to updated her attention

74
00:03:22,769 --> 00:03:25,480
because of the report one arctic

75
00:03:25,479 --> 00:03:28,978
surgeries like that that is because

76
00:03:28,979 --> 00:03:34,229
with percentages alone to store twenty percent zero point to use every things

77
00:03:34,229 --> 00:03:38,479
related to number one zw zero point to strengthen the once was a zero point two

78
00:03:38,479 --> 00:03:42,799
simpson zero point one and let's take that format reduced format on the other

79
00:03:42,799 --> 00:03:45,689
form level one of the report of a sort of formats for now

80
00:03:45,689 --> 00:03:49,189
on the basis of stores occurred that's what makes a lot of simple which is the

81
00:03:49,189 --> 00:03:50,968
bubble tater tots

82
00:03:50,968 --> 00:03:54,568
coaches or when the students now free run this query

83
00:03:54,568 --> 00:03:57,588
beget therefore to ten percent

84
00:03:57,588 --> 00:03:59,669
thank you so much

85
00:03:59,669 --> 00:04:00,909
uh...

86
00:04:00,908 --> 00:04:05,019
soviet school query

87
00:04:05,019 --> 00:04:08,528
invoices extend did

88
00:04:08,528 --> 00:04:12,998
cotton

89
00:04:12,998 --> 00:04:19,709
branislav again crew which is extended to how we got closer for one

90
00:04:19,709 --> 00:04:21,959
comic sinatra need to do

91
00:04:21,959 --> 00:04:23,009
is

92
00:04:23,009 --> 00:04:24,879
with corridor site today

93
00:04:24,879 --> 00:04:28,588
order with our guests are due to an extra for booking items were

94
00:04:28,588 --> 00:04:32,990
and we're going to want to get total costs

95
00:04:32,990 --> 00:04:34,610
for an invoice

96
00:04:34,610 --> 00:04:38,009
a mechanic get sick from another query

97
00:04:38,009 --> 00:04:41,639
query query query costs payments you can

98
00:04:41,639 --> 00:04:45,218
so reading on the carpet booking organising real property nineteen on the

99
00:04:45,218 --> 00:04:45,969
two

100
00:04:45,970 --> 00:04:48,240
just for the sake of argument

101
00:04:48,240 --> 00:04:49,639
and where

102
00:04:49,639 --> 00:04:53,038
interested in public anything that this is the payment

103
00:04:53,038 --> 00:04:56,238
so this is a cost for the booking

104
00:04:56,238 --> 00:04:58,418
this is a cost this is of course this is the cost

105
00:04:58,418 --> 00:05:02,428
so what's the single one of these total up these fields on payment

106
00:05:02,428 --> 00:05:06,179
so it's great cost thanks union looking up amount to much to stop

107
00:05:06,180 --> 00:05:09,358
and this is where we start to make to calculate filled

108
00:05:09,358 --> 00:05:11,589
destruct column in there

109
00:05:11,589 --> 00:05:14,158
prepared to sign an answer column

110
00:05:14,158 --> 00:05:16,089
picking it got a builder

111
00:05:16,089 --> 00:05:20,128
mcauliffe's column total

112
00:05:20,129 --> 00:05:21,610
semicolon

113
00:05:21,610 --> 00:05:22,600
annex

114
00:05:22,600 --> 00:05:24,580
dese some

115
00:05:24,579 --> 00:05:26,109
what we saw a man with something

116
00:05:26,110 --> 00:05:29,129
uh... amount

117
00:05:29,129 --> 00:05:31,020
and where we saw me

118
00:05:31,019 --> 00:05:33,599
well pavers animal but it's not too late

119
00:05:33,600 --> 00:05:38,610
whose query costs payments union trickery costs

120
00:05:38,610 --> 00:05:40,319
payments

121
00:05:40,319 --> 00:05:42,789
union

122
00:05:42,788 --> 00:05:45,838
and what criteria the room

123
00:05:45,838 --> 00:05:47,959
before at the criteria just

124
00:05:47,959 --> 00:05:51,519
closed up rocket off that's ok and run it

125
00:05:51,519 --> 00:05:54,788
so total cost forty thousand forty thousand cuz we havent

126
00:05:54,788 --> 00:05:56,649
possibly caused terrible

127
00:05:56,649 --> 00:06:01,120
we won't bite and to not the payment

128
00:06:01,120 --> 00:06:05,319
colonel selection we want the committee to people popularity so

129
00:06:05,319 --> 00:06:07,428
this proposed to him

130
00:06:07,428 --> 00:06:08,818
to cry tears

131
00:06:08,819 --> 00:06:11,919
uh...

132
00:06:11,918 --> 00:06:14,609
syrups unstoppable committee flute

133
00:06:14,610 --> 00:06:15,499
off to the

134
00:06:15,499 --> 00:06:20,879
closing professional

135
00:06:20,879 --> 00:06:23,240
ninety

136
00:06:23,240 --> 00:06:24,408
equals

137
00:06:24,408 --> 00:06:27,329
ampersand

138
00:06:27,329 --> 00:06:34,329
should be booking t

139
00:06:35,059 --> 00:06:36,330
circling

140
00:06:36,329 --> 00:06:39,058
so it's out there right now

141
00:06:39,059 --> 00:06:41,209
so that we provide them a little bit

142
00:06:41,209 --> 00:06:43,829
now it's get rid of those payments sort of package

143
00:06:43,829 --> 00:06:47,098
although i do tend to run on thinks or comp headwear

144
00:06:47,098 --> 00:06:51,348
closes bill duma that carpet so that you don't if you kill everything including

145
00:06:51,348 --> 00:06:52,259
i_d_ premised

146
00:06:52,259 --> 00:06:53,689
and it doesn't work youth

147
00:06:53,689 --> 00:06:56,639
dot individual try to find out why it didn't work

148
00:06:56,639 --> 00:07:01,379
son did not want to send andrew burke on captioning a string

149
00:07:01,379 --> 00:07:03,430
space and

150
00:07:03,430 --> 00:07:06,199
and then we're saying quite soon

151
00:07:06,199 --> 00:07:08,610
and we don't have to equal payments over

152
00:07:08,610 --> 00:07:11,430
snotty cool we use the

153
00:07:11,430 --> 00:07:14,959
harrahs for left and right that's probably beckoning to okay missus

154
00:07:14,959 --> 00:07:17,329
streamed through text field

155
00:07:17,329 --> 00:07:21,228
uh... so we need to put you single quotation marks sleepless in quotation

156
00:07:21,228 --> 00:07:22,368
mark a

157
00:07:22,369 --> 00:07:23,120
space

158
00:07:23,120 --> 00:07:24,949
ampersand

159
00:07:24,949 --> 00:07:29,519
pathway fragmented space there

160
00:07:29,519 --> 00:07:33,228
after the single quotation mark put payment

161
00:07:33,228 --> 00:07:35,548
menon of the same quotation marks

162
00:07:35,548 --> 00:07:36,998
circling

163
00:07:36,999 --> 00:07:39,460
run-up

164
00:07:39,459 --> 00:07:42,508
okay so good-looking ninety number to reach one thousand four hundred and

165
00:07:42,509 --> 00:07:43,919
twenty flights

166
00:07:43,918 --> 00:07:45,409
without payments

167
00:07:45,410 --> 00:07:47,619
thirteen fourteen

168
00:07:47,619 --> 00:07:48,909
for ten

169
00:07:48,908 --> 00:07:51,129
for twenty five thirty three

170
00:07:51,129 --> 00:07:55,849
okay so on feeding pretty good about that

171
00:07:55,848 --> 00:08:02,009
rini to no need to do is we need to take into account the etienne discount

172
00:08:02,009 --> 00:08:04,158
so discounts pretty

173
00:08:04,158 --> 00:08:06,649
he's actually what for want of ninety three

174
00:08:06,649 --> 00:08:09,800
but was actually discounted by ten percent

175
00:08:09,800 --> 00:08:11,860
so what we weren't he won't

176
00:08:11,860 --> 00:08:14,430
to return ninety percent for eighty

177
00:08:14,430 --> 00:08:16,288
straight up into designed to

178
00:08:16,288 --> 00:08:18,868
to the total cost for the pill dot

179
00:08:18,869 --> 00:08:21,319
uh... before you can do that we just

180
00:08:21,319 --> 00:08:24,658
forty-something ends at this is just uh...

181
00:08:24,658 --> 00:08:29,538
calmer young left for the surrounded with a function of if we get no back who

182
00:08:29,538 --> 00:08:30,748
compasses their art

183
00:08:30,749 --> 00:08:33,220
and now we're going to do you need to multiply

184
00:08:33,220 --> 00:08:34,769
uh...

185
00:08:34,769 --> 00:08:37,169
figure we get back from him

186
00:08:37,169 --> 00:08:39,709
times in this case is there a point nine

187
00:08:39,710 --> 00:08:43,759
but a discount on various is discover scissor point to just twenty percent

188
00:08:43,759 --> 00:08:46,230
juanita multiply by zero point nine

189
00:08:46,230 --> 00:08:48,528
so it will reduce multiplied

190
00:08:48,528 --> 00:08:49,889
times

191
00:08:49,889 --> 00:08:51,860
and then in brackets

192
00:08:51,860 --> 00:08:52,889
one

193
00:08:52,889 --> 00:08:59,139
sort of want to via one

194
00:08:59,139 --> 00:09:02,448
one minus discounts was discovered one so that would be

195
00:09:02,448 --> 00:09:05,269
sir for nine hundred as a discount comes out

196
00:09:05,269 --> 00:09:08,559
so disfigured such a discount was thirty percent

197
00:09:08,559 --> 00:09:11,779
eveyone minus there four three zero point seven

198
00:09:11,779 --> 00:09:14,139
so if we run that now

199
00:09:14,139 --> 00:09:18,110
yes count four three two could be rigid remove ten percent from it

200
00:09:18,110 --> 00:09:23,019
that indexing we need to work out these watched about the eighty

201
00:09:23,019 --> 00:09:23,840
uh...

202
00:09:23,840 --> 00:09:25,710
tiles

203
00:09:25,710 --> 00:09:31,560
monogram because this figure include g_a_t_t_ excess cholesterol used

204
00:09:31,559 --> 00:09:38,139
mask method of hurricane

205
00:09:38,139 --> 00:09:42,189
and

206
00:09:42,190 --> 00:09:44,850
don't remember

207
00:09:44,850 --> 00:09:47,409
remember

208
00:09:47,409 --> 00:09:48,969
okay it doesn't

209
00:09:48,970 --> 00:09:52,540
thousands of the total cost so that you can include it in this

210
00:09:52,539 --> 00:09:54,370
so similar idea

211
00:09:54,370 --> 00:10:00,269
the eighty zero point two serenetech she times gifts buy one

212
00:10:00,269 --> 00:10:04,519
uh... however dat kinda looking down since it was good to stall

213
00:10:04,519 --> 00:10:05,399
reverie

214
00:10:05,399 --> 00:10:06,289
uh...

215
00:10:06,289 --> 00:10:09,870
invoiced level of the eighty about pouring

216
00:10:09,870 --> 00:10:10,678
and

217
00:10:10,678 --> 00:10:15,379
so it might change to zero point one seven five cents for point five percent

218
00:10:15,379 --> 00:10:19,720
a minus twenty percent say and a similar way it's what we did in discount

219
00:10:19,720 --> 00:10:21,330
britannica content

220
00:10:21,330 --> 00:10:22,710
going to go to build up

221
00:10:22,710 --> 00:10:26,500
congregants eight time spent in brackets we're going to put the one

222
00:10:26,500 --> 00:10:30,000
plus community

223
00:10:30,000 --> 00:10:31,240
clint hand-drawn map

224
00:10:31,240 --> 00:10:33,669
and so now we can't do it

225
00:10:33,669 --> 00:10:38,069
for example that was so much for a few domi knocked off ten december two rs

226
00:10:38,070 --> 00:10:39,970
ford

227
00:10:39,970 --> 00:10:41,410
what four three two

228
00:10:41,409 --> 00:10:42,480
and then we've

229
00:10:42,480 --> 00:10:45,369
i did twenty percent awsome book five one eight forty

230
00:10:45,369 --> 00:10:49,509
example of a city and last but not least

231
00:10:49,509 --> 00:10:51,830
estes convert this to you

232
00:10:51,830 --> 00:10:55,200
currency

233
00:10:55,200 --> 00:10:56,610
mama

234
00:10:56,610 --> 00:10:59,220
slightly others total cost

235
00:10:59,220 --> 00:11:03,190
uh... cesar and now we're going to do is really a pat

236
00:11:03,190 --> 00:11:05,380
love affair with him

237
00:11:05,379 --> 00:11:08,029
we're going to call this field

238
00:11:08,029 --> 00:11:09,909
total

239
00:11:09,909 --> 00:11:12,429
payments

240
00:11:12,429 --> 00:11:13,229
uh...

241
00:11:13,230 --> 00:11:16,920
column in just a note from close quotation or that's okay

242
00:11:16,919 --> 00:11:20,269
to go back to total costs

243
00:11:20,269 --> 00:11:24,509
uh... payments rolled discount doesn't affect payments kisses payments is when

244
00:11:24,509 --> 00:11:28,059
they give start-up money to cover the cost of the bill

245
00:11:28,059 --> 00:11:31,599
discount is an important v eighteen imports and get rid of all about

246
00:11:31,600 --> 00:11:34,310
so in fact so we are killing me

247
00:11:34,309 --> 00:11:36,939
scarred from the internet

248
00:11:36,940 --> 00:11:39,380
take up soon including

249
00:11:39,379 --> 00:11:42,009
just before the first asterix

250
00:11:42,009 --> 00:11:43,840
chelsea

251
00:11:43,840 --> 00:11:47,310
total payments could build up

252
00:11:47,309 --> 00:11:48,659
castro back in there

253
00:11:48,659 --> 00:11:51,149
and when you finished trying to be

254
00:11:51,149 --> 00:11:54,019
to hours before he left unlocked equals

255
00:11:54,019 --> 00:11:55,399
so now we're asking

256
00:11:55,399 --> 00:11:57,080
for some

257
00:11:57,080 --> 00:11:58,100
climb a mountain

258
00:11:58,100 --> 00:12:02,550
concurrent cost payments union

259
00:12:02,549 --> 00:12:03,649
where

260
00:12:03,649 --> 00:12:05,409
i to me who's playing

261
00:12:05,409 --> 00:12:07,789
obviously but republican

262
00:12:07,789 --> 00:12:13,329
all right anything else that plus roundup

263
00:12:13,330 --> 00:12:17,320
should be a and we get co-payments call

264
00:12:17,320 --> 00:12:20,250
the number one four hundred ninety roamed let's go back to the following

265
00:12:20,250 --> 00:12:21,340
you

266
00:12:21,340 --> 00:12:22,320
and that's just

267
00:12:22,320 --> 00:12:23,710
uh...

268
00:12:23,710 --> 00:12:25,720
enclosed this

269
00:12:25,720 --> 00:12:26,820
and another

270
00:12:26,820 --> 00:12:28,560
cartooning

271
00:12:28,559 --> 00:12:32,179
converting function press return family get total cost is five one eight four

272
00:12:32,179 --> 00:12:35,259
two u_s_ minus discount including dat

273
00:12:35,259 --> 00:12:36,460
and they've paid

274
00:12:36,460 --> 00:12:39,759
four hundred eighty pound towards that

275
00:12:39,759 --> 00:12:41,819
and some levine

276
00:12:41,820 --> 00:12:46,030
time burst on the two total cost is also seventeen ten forty

277
00:12:46,029 --> 00:12:49,490
paid four hundred and four thousand sixty which is obviously ridiculous

278
00:12:49,490 --> 00:12:50,490
length

279
00:12:50,490 --> 00:12:55,269
smacks of major spring figures in their to test the uh... that in itself badly

280
00:12:55,269 --> 00:12:58,500
progress will exchange that figure and make it more

281
00:12:58,500 --> 00:12:59,389
terrible

282
00:12:59,389 --> 00:13:00,960
i think so

283
00:13:00,960 --> 00:13:04,060
that's it for this particular videotape uh...

284
00:13:04,059 --> 00:13:05,689
hope u understood

285
00:13:05,690 --> 00:13:09,270
what we're trying to do is discounting dat if you didn't

286
00:13:09,269 --> 00:13:12,189
for free to go back and watch the video again its

287
00:13:12,190 --> 00:13:16,290
also is a little bit important to making invoices system you do after

288
00:13:16,289 --> 00:13:18,879
deal with things like discount andrea terry

289
00:13:18,879 --> 00:13:20,009
uh...

290
00:13:20,009 --> 00:13:23,879
calculated field so that you cannot do that skycap let phyllis

291
00:13:23,879 --> 00:13:26,139
and comforted by thinks i've seen

292
00:13:26,139 --> 00:13:28,549
paying the to get more mobile king

293
00:13:28,549 --> 00:13:29,659
balloting

294
00:13:29,659 --> 00:13:30,019
the invoice