If you are unable to create a new account, please email support@bspsoftware.com

 

Analyze data within a range of rows and return first positive row value

Started by naveen10046, 24 Jun 2016 01:17:10 AM

Previous topic - Next topic
Print
Go Down Pages1
User actions

naveen10046

24 Jun 2016 01:17:10 AM
Hi Guys,

I am stuck with below requirement where I would need to populate a field 'deficit resolved time'.  Any suggestion would be grateful.

account1, account2, transaction_time , transaction_amt, deficit resolved time
A                A1             10:00                  10000 
A                A1             10:10                  -5000                    10:40
A                A1             10:20                  -6000                    10:40
A                A1             10:30                  -4000                    10:40
A                A1             10:40                    3000
A                A1             10:50                  -2000                    11:00
A                A1             11:00                    5000             
Print
Go Up Pages1
User actions
BSP Software Documentation
MetaManager Documentation and Knowledgebase
Version Control Documentation and Knowledgebase
BSP Software Resources About Us
MetaManager BSP Software Training BSP Software
Integrated Control Suite YouTube Channel Micro Strategies Inc
Security Migration IBM Cognos
Integrated Management Suite