https://community.blueprism.com/t5/Product-Forum/Formula-Writing/m-p/66398#M19003 <P>I am trying to use one formula for the total amount. Below is the scenario</P> <P>"<STRONG>If total amount found use it as total amount else sum all the net amounts of the table columns</STRONG>"</P> <P>&nbsp;</P> <P>For this using bellow formula as guided by decipher document but if the fields found still it is showing that total amount is not equal to the sum of net amounts</P> <P>IF(VAREXISTS((FT_3_USER_FIELD)),SELF&nbsp;,FT_5_ITEMS_0:#)</P> <P>&nbsp;</P> <P>Please let me know how I can correct it ?</P><BR /><BR />------------------------------<BR />Ankit Dwivedi<BR />------------------------------<BR /> Fri, 18 Dec 2020 08:09:00 GMT AnkitDwivedi 2020-12-18T08:09:00Z https://community.blueprism.com/t5/Product-Forum/Formula-Writing/m-p/66398#M19003 <P>I am trying to use one formula for the total amount. Below is the scenario</P> <P>"<STRONG>If total amount found use it as total amount else sum all the net amounts of the table columns</STRONG>"</P> <P>&nbsp;</P> <P>For this using bellow formula as guided by decipher document but if the fields found still it is showing that total amount is not equal to the sum of net amounts</P> <P>IF(VAREXISTS((FT_3_USER_FIELD)),SELF&nbsp;,FT_5_ITEMS_0:#)</P> <P>&nbsp;</P> <P>Please let me know how I can correct it ?</P><BR /><BR />------------------------------<BR />Ankit Dwivedi<BR />------------------------------<BR /> Fri, 18 Dec 2020 08:09:00 GMT https://community.blueprism.com/t5/Product-Forum/Formula-Writing/m-p/66398#M19003 AnkitDwivedi 2020-12-18T08:09:00Z