on 03-08-2018 4:00 AM
Hi,
I am developing the cognos reports to webi and looking for help in writing the below formula. The backend database being used is Sql server.
I need help in writing the below formula in Webi using backend database as sql server.
maximum(if([Database View].[Suspense workflow_events].[status]='Posted') then (_add_hours([Database View].[Suspense workflow_events].[created_at], -5)) else (null) for [Database View].[Suspense workflow_events].[entity_number])
maximum(if([Database View].[Suspense workflow_events].[status]='Submitted')
then ([Database View].[User - Suspense Workflow Events].[User First Name]+' ' +[Database View].[User - Suspense Workflow Events].[User Last Name])
else (null) for [Database View].[Suspense workflow_events].[entity_number]) .
Appreciate your help and many thanks in advance.
User | Count |
---|---|
81 | |
24 | |
11 | |
9 | |
7 | |
5 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.