New Field add using current data field

[Dhanushka_S]

Hi,

I want to add new data field by summarising current data data field,

exp,

POLICY_NO	CLA_CODE	VAT %	New Field to be added
KU00221H0000880	MC	0	VAT 0%
99KUAP000082	MS	0	VAT 0%
99KUAP000082	MS	0	VAT 0%
KU0014PD0000012	PP	0	VAT 0%
KU0021CF0004459	FR	0.08	VAT 8%
KU00221C0007999	MC	0.08	VAT 8%
KU00201M0000990	MC	0.08	VAT 8%
KU00201F0004493	MC	0.08	VAT 8%
KU00191W0000737	MC	0.08	VAT 8%
KU00223C0007550	M3	0.12	VAT 12%
KU00153C0005228	M3	0.12	VAT 12%
KU0020DF0001907	FR	0.12	VAT 12%
KU00213C0007274	M3	0.12	VAT 12%
KU0019PH0004631	CH	0.12	VAT 12%
KU0018DF0001705	FR	0.12	VAT 12%
KU00171W0000491	MC	0.12	VAT 12%
KU00211A0010669	MC	0.12	VAT 12%
KU0021LI0001444	PP	0.15	VAT 15%
KU00201F0004598	MC	0.15	VAT 15%
KU0022PH0004863	CH	0.15	VAT 15%
KU0022PH0004864	CH	0.15	VAT 15%
KU0022PH0004865	CH	0.15	VAT 15%
KU00223F0145698	M3	0.15	VAT 15%
KU00223F0145697	M3	0.15	VAT 15%
KU00223F0145699	M3	0.15	VAT 15%

I try it as follows but its not working.

(VAT%) <='.01' ,'0%' and  >='.02'  <='.08' ,'8%' and >='.09'  <='.012' ,'12%'   AS "VAT_%"

Requesting your support regarding this.

Thanks

Dhanushka

[sidhiq91]

@Dhanushka_S  Instead of trying this in the back end: 

Can you please try in the front end please, you just have to make changes to the format: