View Single Post
 
Old 02-03-2020, 09:44 AM
Naveen Dhanaraj Naveen Dhanaraj is offline Windows 10 Office 2019
Novice
 
Join Date: Jan 2020
Posts: 20
Naveen Dhanaraj is on a distinguished road
Default

Even though if I have syntax error now values are returning.


I have 13 values which are coming from field,11 values are coming as expected but other two values are not populating ,its coming as -8 -8 . Do I need to make any change in formula ?

This is My Formula,

{=MOD(INT(«ACCOUNT_NUMBER»/100000000000),10)\#0}
{=MOD(INT(«ACCOUNT_NUMBER»/10000000000),10)\#0}
{=MOD(INT(«ACCOUNT_NUMBER»/1000000000),10)\#0}
{=MOD(INT(«ACCOUNT_NUMBER»/100000000),10)\#0}
{=MOD(INT(«ACCOUNT_NUMBER»/10000000),10)\#0}
{=MOD(INT(«ACCOUNT_NUMBER»/1000000),10)\#0}
{=MOD(INT(«ACCOUNT_NUMBER»/100000),10)\#0}
{=MOD(INT(«ACCOUNT_NUMBER»/10000),10)\#0}
{=MOD(INT(«ACCOUNT_NUMBER»/1000),10)\#0}
{=MOD(INT(«ACCOUNT_NUMBER»/100),10)\#0}
{=MOD(INT(«ACCOUNT_NUMBER»/10),10)\#0}
{=MOD(INT(«ACCOUNT_NUMBER»/1),10)\#0}

Received Output Value:
0 1 3 0 1 0 9 1 7 6 1 -8 -8 <<<<<like this

Expected Output Value:
130109176110

Thanks,
Naveen
Reply With Quote