BusinessObjects Board

Need help with True or False Formula

Hello,

I am converting a Crystal report to BO report and below is the formula in Crystal Report. I am not able to understand what this Formula field meaning…

Under Formula fields there is a Formula named IncludeHeld …below is the formula in that field

formula = true
'formula = false

There are using that in the Filters as below…

// include held
((({@IncludeHeld} = true) and ({Transactions.PermInvalid} = false)) or
// do not include held
(({@IncludeHeld} = false) and ({Transactions.Invalid} = false)))

What is Includeheld will hold value is it true or False…

Thanks in advance…


Rajua99 :india: (BOB member since 2004-12-16)

Maybe I have worked too long with Crystal Reports, but it seems pretty clear to me.

If the formula {@IncludeHeld} returns a True and the field {Transactions.PermInvalid} is False (apparently it is a Boolean field)

or

the formula {@IncludeHeld} returns a False and the field {Transactions.Invalid} is false (again a Boolean field). Then we want that record.

From my experience with Webi. The formula {@IncludeHeld} will have be recreated in the universe.


kevlray :us: (BOB member since 2010-06-23)