cancel
Showing results for 
Search instead for 
Did you mean: 

Urgent Pls. WebI Formula

erdem_sephanelioglu
Participant
0 Kudos

Hi gurus, I am not sure if WebI let the scenario be real on the tool, I am in need ot creating a measure or dimension for the below mentioned case.

Beg Date Criteria

1-if Beg End Date is empty for each Prod Order Trans of one particular Prod Order then Beg Date is Created On

2-If one specific order has more than two Prod Order and Beginning and End dates are not null then Beginning date of the subsecutive line

Please refer the picture attached.

I wonder If BO is capable of doing this achieve.

Many thanks

Eddy.

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

This is definitely possible..

1. for requirement 1 just create a variable using if condition  something like this and use that

=IF  [Beg Date] is NULL then [Created On]

For requirement 2

2. Create a variable to get the number of prod order in  a order.. something like below , call it "Count prod order"

=Count([prod order]) forall ([prod order])

3. now create another variable for this

=IF [Count prod order] > 1 and [Beginning Date] is not NULL and [End dates] is not NULL then [Beg Date]

p.s. I could not understood what you meant by "Beginning date of the subsecutive line" I assume its begin date

erdem_sephanelioglu
Participant
0 Kudos

Hi can you combine those input in one variable as all these requirement is to obtain beginning date

With subsecutive I mean "one line below" in other words next value for the same column

Former Member
0 Kudos

I thought there are two output values you are looking for and you can get try relativevalue() function for next line record... You need to make changes to the slicing dimension based on your need in relative value clause...

You can just combine them to get the one variable something like

=IF  [Beg Date] is NULL then [Created On]  else if

[Count prod order] > 1 and [Beginning Date] is not NULL and [End dates] is not NULL then relativevalue([Created On];([Prod order]);1)

Former Member
0 Kudos

In my opinion for scenario 1st it's better to you use below condition.

It will make sure that both beg and end dates are NULL for Each "Prod Order Trans".

If ( ([Beg Date]) && [End Date]) = NULL ) ForEach([Prod Order Trans])

Thanks,

Vivek