BOB: Business Objects Board
Not endorsed by or affiliated with SAP

Register | Login 

Want to sponsor BOB? 
Want to sponsor BOB? (Opens a new window)  

General Notice: BOB is going to retire...please see details here.
General Notice: No events within the next 45 days.

[BOBJ 4.x] Previous Function


 
Search this topic... | Search Desktop Intelligence... | Search Box
Register or Login to Post    Forum Index -> Building Reports -> Desktop Intelligence  Previous TopicPrint TopicNext Topic
Author Message
nancet
Forum Member
Forum Member



Joined: 12 Mar 2020

Posts: 1



PostPosted: Thu Mar 12, 2020 10:07 am 
Post subject: Previous Function

Can someone explain to me why the Previous function does not work correctly in this formula? It seems to work perfectly when I only have 1 or 2 clients. On Gardin, the first row should say No Credit because the Weight of Part is =< the Previous part.

= If IsNull ([Authorized Case Credit Total]) Then "PSX Not Started" Else If [Investigation Client ID] = Previous ([Investigation Client ID]) And ([Weight of Part(s)] <= Previous([Weight of Part(s)])) Then "No Credit" Else ([Authorized Case Credit Total])


Clinet Id Weight of Part Authorized Case Credit Total
Alexander 44.93 67.57
Alexander 39.71 No Credit
Phillips NULL PSX Not Started
Gardin 44.27 59.15 (Should be No Credit)
Gardin 44.27 No Credit
Gardin 44.93 59.81
Back to top
Display posts from previous:   
Register or Login to Post    Forum Index -> Building Reports -> Desktop Intelligence  Previous TopicPrint TopicNext Topic
Page 1 of 1 All times are GMT - 5 Hours
 
Jump to:  

Index | About | FAQ | RAG | Privacy | Search |  Register |  Login 

Get community updates via Twitter:

Not endorsed by or affiliated with SAP
Powered by phpBB © phpBB Group
Generated in 0.0268 seconds using 17 queries. (SQL 0.0025 Parse 0.0008 Other 0.0235)
CCBot/2.0 (https://commoncrawl.org/faq/)
Hosted by ForumTopics.com | Terms of Service
phpBB Customizations by the phpBBDoctor.com
Shameless plug for MomentsOfLight.com Moments of Light Logo