Baanboard.com

Go Back   Baanboard.com > Forum > Baan Quick Support: Functional & Technical > Finance, Invoicing and Integration

User login

Frontpage Sponsor

Main

Poll
As a Customer What would do to keep your ERP Implementation intact
Proactively define Business Process-- Take the Project Ownership
50%
Handover everything to System Integrator from drawing BP till implementation of ERP
0%
Hire more inhouse skilled & capable IT Resource to work directly with SI
50%
Rely on SI Architects/Consultants
0%
Total votes: 2

Baanboard at LinkedIn


Reference Content

Reply
 
Thread Tools Display Modes
  #1  
Old 20th May 2020, 09:52
pegaga1979 pegaga1979 is offline
Senior Member
 
Join Date: Oct 2008
Posts: 186
pegaga1979 is on a distinguished road
Baan: Baan V - DB: SQL - OS: WINDOWS 2003
How to set 0 if calculation is 1 divide to 0 in financial statement
Baan: Infor ERP 10.6

Hi,

In Financial Statement, at column percentage i have issue when amount divide by 0, which resulted in Text "no col..".
I want it change to 0 for undefined percentage.
Your advises are much appreciated.
Thank you.
Stay Safe.
Reply With Quote
  #2  
Old 20th May 2020, 10:31
bhushanchanda's Avatar
bhushanchanda bhushanchanda is offline
Guru
 
Join Date: Sep 2012
Location: India
Posts: 2,444
bhushanchanda has a spectacular aura aboutbhushanchanda has a spectacular aura aboutbhushanchanda has a spectacular aura about
Baan: LN FP 1-9, 10.4, a little bit of Baan IV - DB: SQL Server 2008, Oracle - OS: Windows Server 2008 R2, Unix
Basically, you would need to check the value of your Divisor before going ahead with division.

e.g. If the calculation is at Report Script level. Instead of

Code:
detail.1:
before.layout:
percent = x/y

You can do something like this -

Code:
detail.1:
before.layout:
     if y > 0 then
           percent = x/y
     else
           percent = 0
     endif

That would make sure you don't get Divide by Zero errors.
__________________
Regards,

Bhushan

Unless you try to do something beyond what you have already mastered, you will never grow!
Reply With Quote
  #3  
Old 21st May 2020, 03:07
pegaga1979 pegaga1979 is offline
Senior Member
 
Join Date: Oct 2008
Posts: 186
pegaga1979 is on a distinguished road
Baan: Baan V - DB: SQL - OS: WINDOWS 2003
Hi Bhushan,
In FS, in that field, it just stated "columnvalue(1,2)".
because the precentage, i already calculate from FS session.
and i have so many line details. so, the script it should be?
Reply With Quote
  #4  
Old 21st May 2020, 07:09
bhushanchanda's Avatar
bhushanchanda bhushanchanda is offline
Guru
 
Join Date: Sep 2012
Location: India
Posts: 2,444
bhushanchanda has a spectacular aura aboutbhushanchanda has a spectacular aura aboutbhushanchanda has a spectacular aura about
Baan: LN FP 1-9, 10.4, a little bit of Baan IV - DB: SQL Server 2008, Oracle - OS: Windows Server 2008 R2, Unix
Ah, I didn't see it was for Financial Statement. You can check if you can use Problem Texts to handle them. You can check the same in this document -

https://docs.infor.com/ln/10.5/en-us...tug__en-us.pdf
__________________
Regards,

Bhushan

Unless you try to do something beyond what you have already mastered, you will never grow!
Reply With Quote
Sponsored Links
Reply


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Compilation error KiranKrishna Tools Development 10 14th January 2020 12:46
Programming Question mr_suleyman Tools Development 37 11th November 2016 08:14
Which Set Commands Do You Use? Why? mr_suleyman Tools Development 14 16th January 2014 21:44
BW client parameters lsatenstein Tools Administration & Installation 2 31st January 2012 21:29
Detected database server termination (help! aide! ayuda! hilfe! ayuto! hellup! •‚¯!)! Francesco Operating Systems & Databases 15 20th July 2002 11:37


All times are GMT +2. The time now is 00:57.


©2001-2018 - Baanboard.com - Baanforums.com