cancel
Showing results for 
Search instead for 
Did you mean: 

Formula Writing

AnkitDwivedi
Level 2

I am trying to use one formula for the total amount. Below is the scenario

"If total amount found use it as total amount else sum all the net amounts of the table columns"

 

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

IF(VAREXISTS((FT_3_USER_FIELD)),SELF ,FT_5_ITEMS_0:#)

 

Please let me know how I can correct it ?



------------------------------
Ankit Dwivedi
------------------------------
0 REPLIES 0