Input
Output
iVBORw0KGgoAAAANSUhEUgAAAXoAAAA0CAIAAAAL52RvAAAAAXNSR0IArs4c6QAAAARnQU1BAACxjwv8YQUAAAAJcEhZcwAAEnEAABJxAfPceo4AAAASdEVYdFNvZnR3YXJlAEdyZWVuc2hvdF5VCAUAAA0cSURBVHhe7Z3fjhXHEYf9Bs4bxG+A38B+A/sN7DdI3sBccYcSKXBhCQkuLPliibGEfcNeJGKvFiFhNgoKijFai+BVEPJCIrAlS+TbU72V2uo/02dn5uyedX1qjU7XVPd0D1O/qZ4zZ3nrTRAEwUoIuQmCYEWE3ARBsCJORm7+8uQ/Nx7tp0qwDjx58uTu3bu7u7upHgTLs2q5efzi5/e/+PatP31DSaZgHQi5CcazUrm59+zVbz79m2jNsnLz40+/nN/eQ6oQrGQKVkjITTCelcrNJ9s/qNYsJTdWp1iIJWuwQkJugvGsh9y8/emOtgq5ORFCboLxrIfc2FYhNydCyE0wnpCboIuQm2A8ITdBFyE3wXhCboIuQm6C8YTcBF2E3ATjGZCbH3/65Y/fPPt48/v3v/jWvjJDeffzh9jZe+/Zq+Q9xMnKDeM8v733+9v/Yi5s+fzloxdpXzBEyE0wngG5+eCr72yo18o71x4QwIMv4C0lN3+49290gYKu2VZoHEphy6AAXX3w3GmlFuz0gKom1xLs/euT/0pJpsXvMES5RLySdQG71L/ds6JNrHbzWftJpgp2hDO9BhlyE4xnQG4+2tx18dkohG5qVmEpubGe7fLen/+Z2mQQh06tigWfhi5YzUUE8URi1CIluS6wdk5gstZBDdX/t9f+nqxH3zb63e0nyZrh5thzxGMQchOMZ0BuuOty0RPPhBxiYQsWGw9S2okGraxzslawnu3SkJtzn/8jd5bi7ERsapNhnZl1nii5AVh5GpRgsIPkFCXrIr9TO6V2blEi67bW2c3+/j6HAD4kU5PXr1+LPyRTnU43RQbDIVJ9wbKd7O3tuU7EwjbVSxR9BluBjNmdPSzWKNUexH9Cxj4qdgoyodzkSlErNkQt7nBUbQrDZxeotX5ybXLFJRQ3Hu3bve3fvqMO1tmJhT0JrFjzFIwTrg6U2hTGM6vcEAk3b968fPnyBQPVzc1NF+0Cxq2trStXriTXQ7Ds7OwkpwzxuXXrVqo3efjwofi7KYuR0aZ6k9u3b4u/7eSzzz7DwjbVSxR9Fj1duH//fqqXkCOyTfUF0lCNUu1BTsLFixcbMscucb5z504y1RkrN+5yn1BulKUOobgwJlNIO45iFYd4Ttaj5HJDWofEMJJ7z16xzVWANZE6t1c3NoVxWRLQv+6luCUVx2XMuhdtSjtmYD65IX7kei3Ctc5Fn1wXcH1jTLsXEJbWgugUwyPtvnBhMEeAS5cuiXNRbmDwVKCJOqoJ5aYd/NPKDc6Dox10sJxZubE6Yh+IOIhYdaMUO3dyQ1TbB7pFXN6U65Fihenqg+fJanAnzY7QHWVwVGOYSW64JS4u7AOIBxtIHIskAvvGxkYyHdUa9lp/UiR6kL3FmJRWMBgbVgFrcjPYiUS+MKHcAHpaTPpADqrKIkgrZ1QYmzgU/3E5q7K3mFXpiWoooOXMyo19rlRLbQSrJowwWQ3WgW57otrlVkUdAZu80HNNlYpLKndaiiOfkDnkhmtULtbGHRu7DS1dQLmUR8FfFAfPZDoEo0pVYyKalUiC4zwXrVM/jXVNo5ORciPd1lZzk8sNSJ+sbZ3G6Rw716dwNuXm2KP64KvvktVg5SZf79SwGlHsFmx60lhzuenIksr2T4rUSKAmYQ65kaCCznuj3ktrkSNo/Dg5ECOxwZbgSdYMiS7cZHhuygddLAbAttGJ5GVs806KUuIo+mABPQlFsZOBufMj/rWTpqer8Y8roul6kGOhOE6GGpxNuXHf6SRrBTuqopocT27s19uUohzYFKw9L7du+vDrx7bac05GMrncaJZeu1HnSGrTc303wlXvycVwlb1yCOmkKDfaSTGGZWo48CHvpDg2R9EHC/BBtAxymRYJcKMS5+JQoUdu1IcZiUX/+WppZpGzKTdkCrZJslaYSW7QF21FyddT9gusxtMlgd7sUx5bJNmZm8nlRu/SndcrES7+PfKkj4RSfYFaGrdliWSJzFwp4KCLRScy/mN0UpQSR9EHC/CBI4ry5gscmZpTlkW7UXIDGxsb+Fy/fl2qPbPI6ZIbrvUvH704v73HTVXeo9XiXqI7JXJjBYLixuyK/XJnQrkBq3ocKFkPsXt7JMOdBykrWEYJk8uNBAZ0rqQ0KmphYymGkFjkc3F1IHdsdkkMS0S5KR90cbQT9+RCU5taJz2BWvTBAvJZH1Fp/AtyVt28Fu3Gyg3zkiPipk002elkQG4ev/j5483v3SXeKKdTbvrLtHLjXsCx79S43Me9blPDLakoK/sPLeaTm1QfQi/xWthY1NkOWCzyWXMTGzByA9dFVq4UcNDFYSd6FNuJtNKXUPJOilLiKPpggVSpPMmSs+pOUe5mKZ6rIpIzMioZXs8/hKMlN+T/tZ8a1coccuMegswqN8XntceWG7ArIPsFmZ3Uue73ZZzy9ryyPBXzyU3nHVKjoucqL4aQWFLlMKR1aSZNSFikCuLgpnzQRdaJphg9nYiFbaqXKPpggVRZII+9QfuXs+pOkfjUzpuMGdxMi+g3g5oDLkVVbrjfOq0hKtALCndUrnst1odqal/ieHLjWrUPIViBYNg61MGS2h9ljNzYwdvfSdg+88c6NZiLtpJC/2nfzMwnN519snwQ/x65kddhwWqZWFLFhJms5mq64Ia3aPH/TnRU4iZNND+CWrdsU71E0QcLpMoh7vH53HKjJ3apJ8RKVW7sD3/aL5uoG6UWscKJyM34FGCM3LgXcGTR5IydD1/cedAy69t9yuRyoxduj3wI8qwkf6EmR277NsuAxdGOhKusnohqWZi48JaYd1M+6OJoJ/JgGGeJ28FO9KCpXkJaOR8skCqHoKfySEVOy9xys5RzTlVu7AXdfk3Oep5CuaEk63EZIzdgm8uZtN/TN163sdgXAl1p/Lh0QiaXG5A4aby94pDAHrzWuc9Lz7pQEqRtqiwgVsUo/u6hda4UsHD3nehE2Dr/vBNRBJqkegkR1qJqpIpBhRuRXUu5IaTtBd2O8H7PlcmNazLyu5uRcmMf08jPsuyaqPNZr21CsuleLGK+yW825pAbiQ2oRYJD1YE7eePBgaqSXUmBGFPlEH384bQJOuUGdCIuH4G8E11/2TWXRUPayZ8YU+UoOgtZW6233CRrBeu5lNwcbxHRIzdu/P0PR4qMlBumaV/ns+oz+LqN4MRFUiQ7KsrcS6o55EbTEKj9nphAskKggU1cOTUBOrx+/bo45B2KPVUOkTFA3lu/3CzbiRjxz88nEoOdvblyHRy4IjcgfQrrLTftCO/3PIZwgAu2nnTAfc2cv/OyFCPlBtxrh1p6Xrdxz+x1ANitis29pJpDbkCjC1iMoBEcQuCzLE9cGGvyAojL1tYWqwm22LWrPFUB2ZUqBsQCUsXQLzewVCdMR4fKFHZ2dhYz3t3c3BQje11qA7IrVTI4uva5ZnLjnhQ0sgP31LOtIPbGTul8bOG0r7OVi/AxCc54uXFT0CJPjtvYo6Mvtkkx65mJmeQGiCtZAhQhXPPAYxkiTzdysNcWKeKQKh0sJTc1ip1AY9ZMIZ8yyN5UKaFasGZyA/bO+c61B3lgIEn5G4DcY+XvB5NQ5BGeP+/EU3omH5EXl/NFgVM0iv5dZLb9rXArLt8ahxbGyw3kP0E41/G6jROU/BmNHRtJkJyWOZhPbgQyFFISgpNbNPHGB5ZR7cPRhBDa2NjAmS2fsaR9JXCDVOmAAeDvIn+SThSUkZGL7jBrPte0EnoOzRnIO5GGtZ4ZmzjUBmlZyjmnKjf5C6woiPwHBh9+/di++F8rxW+gaz/80TL4m+xiKS4l3NpNCp4yEflBhp1IbT0yidzkgxlMuNAOu4wqypNT1ZHLxgZzy03wa6AqN9zzB6WBgk9DC/J8obas0FIUqTwtyktyPUrtoUmtFNOfSeQmz7aKx7K4E1tLvpyQzbSkCrkJxlOVG+D6zl9jtYUMiJghkOzKS4t70KBwVy/6S6n9aZgbj/YbrRoLkzxNa5TigCeRG7D9DD6Bcs+50JS0o4T9Z5ppSRVyE4ynJTcC1z0SoJkOMU/YcAu1N2c+Ez/qw9VPkDcuevzpgW7pSjqkEFG1G7hQbMWBBr+rYiQMr6FWjLwxYAYmbdkOroAaMHI94uCYmalMUOaYrBU4b+pMaZ/G4xFyE4xnWG7OEsQhcY58SCGkWdzNkQvkcBTVGmQrWdeHkJtgPL8uuTlB7JpuMFs5hYTcBOMJuVkFLAPtd0yryaemJeQmGE/IzSpg4aZa896Ih80nSMhNMJ6Qm9m59+yVTW3aL16fWkJugvGE3MwIa6jz23tWa9Y0tYGQm2A8ITcTg6AgK+8e/YvxUt6u/8d1p5+Qm2A8ITcT4yRGC1ozx+swKyPkJhhPyM3EOJWR8tHm7vrmNULITTCekJuJ0fee2X6y/cPVB8/X8WvvnJcvXz59+jT/81FB0E/ITRAEKyLkJgiCFRFyEwTBSnjz5n+Bsg0wC+hiuAAAAABJRU5ErkJggg==
Weekly Challenge #209
C:\Users\MOHAMM~1\AppData\Local\Temp\Engine_67860_7aa85d2910234a4a90158aebe16451c6_\Engine_28008_1b63ff9568424a669bd55c55a1c36a4b_.yxdb
Single
Profile
24-04-2017
2017-04-01
10320
1849
1985974.59
1985974.59
0
0
0
24-04-2017
2017-05-01
10385
8324
8064636.49
8064636.49
0
0
0
24-04-2017
2017-06-01
10382
5859
5279349.51
5279349.51
0
0
0
24-04-2017
2017-07-01
10375
7496
7377419.28
7377419.28
0
0
0
24-04-2017
2017-08-01
10393
7262
7265501.55
7265501.55
0
0
0
24-04-2017
2017-09-01
10405
6407
6992772
6992772
0
0
0
24-04-2017
2017-10-01
10450
8344
7319265.22
7319265.22
0
0
0
24-04-2017
2017-11-01
10489
8713
7858932.5
7858932.5
0
0
0
24-04-2017
2017-12-01
10494
8640
7878868.83
7878868.83
0
0
0
24-04-2017
2018-01-01
10433
8686
8421750.49
8688719.98
0
0
0
24-04-2017
2018-02-01
10289
8334
7281329.36
7512147.5
0
0
0
24-04-2017
2018-03-01
10061
9052
7849509.59
8098339.05
0
0
0
24-04-2017
2018-04-01
9960
6903
6057094.47
6249104.36
0
0
0
24-04-2018
2018-04-01
9663
1293
1408698.12
1453353.85
0
0
0
24-04-2018
2018-05-01
9586
6092
5937072.15
6125277.33
0
0
0
24-04-2018
2018-06-01
9467
4485
4079795.07
4209124.58
0
0
0
24-04-2018
2018-07-01
9403
5341
5916140.24
6103681.89
0
0
0
24-04-2018
2018-08-01
9323
4946
4593841.41
4739466.18
0
0
0
24-04-2018
2018-09-01
9266
6038
5757437.57
5939948.34
0
0
0
24-04-2018
2018-10-01
9250
6445
6374160.02
6576220.9
0
0
0
24-04-2018
2018-11-01
9203
6180
4958654.43
5115843.78
0
0
0
24-04-2018
2018-12-01
9173
6705
6088946.97
6281966.59
0
0
0
24-04-2018
2019-01-01
9163
6913
6620825.7
6830705.87
0
0
0
24-04-2018
2019-02-01
9137
6535
5562491.74
5738822.73
0
0
0
24-04-2018
2019-03-01
9158
6869
5507350.9
5643894.98
0
0
0
24-04-2018
2019-04-01
9105
5484
4223102.68
4323390.35
0
0
0
24-04-2019
2019-04-01
8952
1391
1481993.93
1510717.28
0
0
0
24-04-2019
2019-05-01
8959
5465
5287881.47
5408356.66
0
0
0
24-04-2019
2019-06-01
8925
4548
3942014.75
4042258.21
0
0
0
24-04-2019
2019-07-01
8926
5525
5316636.58
5452801.74
0
0
0
24-04-2019
2019-08-01
8973
4230
3573086.99
3655762.26
0
0
0
24-04-2019
2019-09-01
9004
5748
5467749.6
5587539.1
0
0
0
24-04-2019
2019-10-01
8999
6383
6342485.89
6476909.48
0
0
0
Inception 24-04-2019 Claims Processed to 31/10/2019
Expiry 23-04-2020 Class VIP
Deductible 20 % OHN 100 OCN 100 MPN 75 Dental Limit 2,000.00 Optical Limit 400.00
Annual Limit 500,000.00 In- patient limit 500,000.00 Out patient Limit 500,000.00 Maternity Limit 500,000.00
Annual Claims No. of Lives No. of Paid Amt of Paid Claims Amt of Paid Claims No. of OS Amt of OS Claims Amt of OS Claims
Claims (before VAT) (after VAT) Claims (before VAT) (after VAT)
Period
Last Policy Year
1 04/2019 8,844 1,390 1,481,798.93 1,510,522.28 0 0.00 0.00
05/2019 8,849 5,451 5,277,674.00 5,398,082.71 0 0.00 0.00
06/2019 8,817 4,528 3,924,225.84 4,024,250.50 0 0.00 0.00
07/2019 8,821 5,509 5,294,859.51 5,430,547.20 0 0.00 0.00
08/2019 8,868 4,214 3,558,281.52 3,640,881.47 0 0.00 0.00
09/2019 8,900 5,734 5,458,328.10 5,578,056.16 0 0.00 0.00
10/2019 8,897 6,363 6,332,559.68 6,466,712.77 0 0.00 0.00
Inception 24-04-2019 Claims Processed to 31/10/2019
Expiry 23-04-2020 Class C
Deductible 20 % OHN 100 OCN 100 MPN 75 Dental Limit 2,000.00 Optical Limit 400.00
Annual Limit 500,000.00 In- patient limit 500,000.00 Out patient Limit 500,000.00 Maternity Limit 15,000.00
Annual Claims No. of Lives No. of Paid Amt of Paid Claims Amt of Paid Claims No. of OS Amt of OS Claims Amt of OS Claims
Claims (before VAT) (after VAT) Claims (before VAT) (after VAT)
Period
Last Policy Year
3 04/2019 108 1 195.00 195.00 0 0.00 0.00
05/2019 110 14 10,207.47 10,273.95 0 0.00 0.00
06/2019 108 20 17,788.91 18,007.71 0 0.00 0.00
07/2019 105 16 21,777.07 22,254.54 0 0.00 0.00
08/2019 105 16 14,805.47 14,880.79 0 0.00 0.00
09/2019 104 14 9,421.50 9,482.94 0 0.00 0.00
10/2019 102 20 9,926.21 10,196.71 0 0.00 0.00
Inception 24-04-2018 Claims Processed to 30/04/2019
Expiry 23-04-2019 Class VIP
Deductible 20 % OHN 100 OCN 100 MPN 75 Dental Limit 2,000.00 Optical Limit 400.00
Annual Limit 500,000.00 In- patient limit 500,000.00 Out patient Limit 500,000.00 Maternity Limit 500,000.00
Annual Claims No. of Lives No. of Paid Amt of Paid Claims Amt of Paid Claims No. of OS Amt of OS Claims Amt of OS Claims
Claims (before VAT) (after VAT) Claims (before VAT) (after VAT)
Period
Last Policy Year
1 04/2018 9,553 1,293 1,408,698.12 1,453,353.85 0 0.00 0.00
05/2018 9,476 6,085 5,935,579.58 6,123,737.45 0 0.00 0.00
06/2018 9,359 4,478 4,077,039.68 4,206,281.84 0 0.00 0.00
07/2018 9,293 5,332 5,912,087.23 6,099,500.40 0 0.00 0.00
08/2018 9,214 4,938 4,590,359.30 4,735,873.69 0 0.00 0.00
09/2018 9,157 6,030 5,752,388.11 5,934,738.81 0 0.00 0.00
10/2018 9,139 6,434 6,370,241.49 6,572,178.15 0 0.00 0.00
11/2018 9,093 6,161 4,944,852.33 5,101,604.15 0 0.00 0.00
12/2018 9,066 6,675 6,016,430.17 6,207,151.01 0 0.00 0.00
01/2019 9,058 6,874 6,569,605.81 6,777,862.31 0 0.00 0.00
02/2019 9,033 6,506 5,528,051.70 5,703,290.94 0 0.00 0.00
03/2019 9,045 6,852 5,498,071.03 5,634,522.80 0 0.00 0.00
04/2019 8,994 5,464 4,109,709.82 4,205,807.24 0 0.00 0.00
Inception 24-04-2018 Claims Processed to 30/04/2019
Expiry 23-04-2019 Class C
Deductible 20 % OHN 100 OCN 100 MPN 75 Dental Limit 2,000.00 Optical Limit 400.00
Annual Limit 500,000.00 In- patient limit 500,000.00 Out patient Limit 500,000.00 Maternity Limit 15,000.00
Annual Claims No. of Lives No. of Paid Amt of Paid Claims Amt of Paid Claims No. of OS Amt of OS Claims Amt of OS Claims
Claims (before VAT) (after VAT) Claims (before VAT) (after VAT)
Period
Last Policy Year
3 04/2018 110 0 0.00 0.00 0 0.00 0.00
05/2018 110 7 1,492.57 1,539.88 0 0.00 0.00
06/2018 108 7 2,755.39 2,842.74 0 0.00 0.00
07/2018 110 9 4,053.01 4,181.49 0 0.00 0.00
08/2018 109 8 3,482.11 3,592.49 0 0.00 0.00
09/2018 109 8 5,049.46 5,209.53 0 0.00 0.00
10/2018 111 11 3,918.53 4,042.75 0 0.00 0.00
11/2018 110 19 13,802.10 14,239.63 0 0.00 0.00
12/2018 107 30 72,516.80 74,815.58 0 0.00 0.00
01/2019 105 39 51,219.89 52,843.56 0 0.00 0.00
02/2019 104 29 34,440.04 35,531.79 0 0.00 0.00
03/2019 113 17 9,279.87 9,372.18 0 0.00 0.00
04/2019 111 20 113,392.86 117,583.11 0 0.00 0.00
Inception 24-04-2017 Claims Processed to 30/04/2018
Expiry 23-04-2018 Class VIP
Deductible 20 % OHN 20 OCN 20 MPN 20 Dental Limit 4,000.00 Optical Limit 400.00
Annual Limit 500000 In- patient limit 500,000.00 Out patient Limit 500,000.00 Maternity Limit 500,000.00
Annual Claims No. of Lives No. of Paid Amt of Paid Claims Amt of Paid Claims No. of OS Amt of OS Claims Amt of OS Claims
(before VAT) (after VAT)
Claims (before VAT) (after VAT) Claims
Period
Last Policy Year
1 04/2017 10,257 1,848 1,982,142.74 1,982,142.74 0 0.00 0.00
05/2017 10,244 8,318 8,061,843.40 8,061,843.40 0 0.00 0.00
06/2017 10,240 5,855 5,276,833.05 5,276,833.05 0 0.00 0.00
07/2017 10,239 7,496 7,377,419.28 7,377,419.28 0 0.00 0.00
08/2017 10,258 7,258 7,259,396.55 7,259,396.55 0 0.00 0.00
09/2017 10,270 6,405 6,989,788.39 6,989,788.39 0 0.00 0.00
10/2017 10,316 8,341 7,317,028.12 7,317,028.12 0 0.00 0.00
11/2017 10,357 8,712 7,858,684.62 7,858,684.62 0 0.00 0.00
12/2017 10,363 8,631 7,870,948.90 7,870,948.90 0 0.00 0.00
01/2018 10,305 8,686 8,421,750.49 8,688,719.98 0 0.00 0.00
02/2018 10,160 8,334 7,281,329.36 7,512,147.50 0 0.00 0.00
03/2018 9,951 9,049 7,845,148.44 8,093,839.65 0 0.00 0.00
04/2018 9,855 6,903 6,057,094.47 6,249,104.36 0 0.00 0.00
Inception 24-04-2017 Claims Processed to 30/04/2018
Expiry 23-04-2018 Class C
Deductible 20 % OHN 100 OCN 100 MPN 75 Dental Limit 2,000.00 Optical Limit 400.00
Annual Limit 500000 In- patient limit 500,000.00 Out patient Limit 500,000.00 Maternity Limit 15,000.00
Annual Claims No. of Lives No. of Paid Amt of Paid Claims Amt of Paid Claims No. of OS Amt of OS Claims Amt of OS Claims
(before VAT) (after VAT)
Claims (before VAT) (after VAT) Claims
Period
Last Policy Year
3 04/2017 63 1 3,831.85 3,831.85 0 0.00 0.00
05/2017 141 6 2,793.09 2,793.09 0 0.00 0.00
06/2017 142 4 2,516.46 2,516.46 0 0.00 0.00
07/2017 136 0 0.00 0.00 0 0.00 0.00
08/2017 135 4 6,105.00 6,105.00 0 0.00 0.00
09/2017 135 2 2,983.61 2,983.61 0 0.00 0.00
10/2017 134 3 2,237.10 2,237.10 0 0.00 0.00
11/2017 132 1 247.88 247.88 0 0.00 0.00
12/2017 131 9 7,919.93 7,919.93 0 0.00 0.00
01/2018 128 0 0.00 0.00 0 0.00 0.00
02/2018 129 0 0.00 0.00 0 0.00 0.00
03/2018 110 3 4,361.15 4,499.40 0 0.00 0.00
04/2018 105 0 0.00 0.00 0 0.00 0.00
C:\Users\MOHAMM~1\AppData\Local\Temp\Engine_67860_7aa85d2910234a4a90158aebe16451c6_\Engine_28008_fdc610cdec984601956f8ff523173475_.yxdb
Single
Profile
Field1
RecordID
1
Int32
6
0
Tag Row # in Original Report
Data table
Page Number
Int16
2
Empty
IF Contains([Field1],"Inception") THEN [Row-1:Page Number]+1 ELSE [Row-1:Page Number] ENDIF
Identify Pages
IF Contains([Field1],"Inception") THEN [Row-1:Page Number]+1 ...
RecordID
Data table
V_String
5
Empty
Tag Data Tables
IF Contains([Row-1:Field1], "Last Policy Year") THEN "Yes" EL...
Simple
Contains
Field1
True
fixed
2020-05-22 23:55:32
0
Inception
2020-05-22 23:55:32
2020-05-22 23:55:32
Contains([Field1],"Inception")
Simple
Contains
Field1
True
fixed
2020-05-22 23:55:32
0
Expiry
2020-05-22 23:55:32
2020-05-22 23:55:32
Contains([Field1],"Expiry")
Simple
Contains
Field1
True
fixed
2020-05-22 23:55:32
0
Annual Limit
2020-05-22 23:55:32
2020-05-22 23:55:32
Contains([Field1],"Annual Limit")
Simple
Contains
Field1
True
fixed
2020-05-22 23:55:32
0
Deductible
2020-05-22 23:55:32
2020-05-22 23:55:32
Contains([Field1],"Deductible")
Simple
Contains
Data table
True
fixed
2020-05-22 23:57:14
0
Yes
2020-05-22 23:57:14
2020-05-22 23:57:14
Contains([Data table],"Yes")
Field1
Last
Inception Row
Field1
Last
Expiry Row
Field1
Last
Deductible Row
Field1
Last
Annual Limit Row
Field1
Last
Data Table
RecordID
Page Number Row
V_String
4
Empty
IF Contains([Row-1:Field1], "Last Policy Year") THEN "Yes" ELSE "" ENDIF
Contain Page Number
IF Contains([Row-1:Field1], "Last Policy Year") THEN "Yes" EL...
Simple
Contains
Page Number Row
True
fixed
2020-05-23 00:32:36
0
Yes
2020-05-23 00:32:36
2020-05-23 00:32:36
Contains([Page Number Row],"Yes")
"Field1"
True
True
True
True
False
False
False
False
False
upper
Warning
All
ByName
Dataset
Last
Dataset Row
Warn
Warn
Warn
Simple
!=
Name
True
fixed
2020-05-23 01:00:56
0
Accident Month
2020-05-23 01:00:56
2020-05-23 01:00:56
[Name] != "Accident Month"
,
,
Error
C:\Users\MOHAMM~1\AppData\Local\Temp\Engine_67860_7aa85d2910234a4a90158aebe16451c6_\Engine_28008_782b0100cda94ca3b9c67632aa158993_.yxdb
Single
Profile
Warning
All
ByName
Number fields
Horizontal
challenge_209_Amin