Webi Values from Negative to possitive

building reports webintelligence
1

HI,

we have coded an object in universe whhich will bring amount field as negative or possitive based on the case statement used in the object.

Now the users doesnt want the amount to come possitive and negative as when they sum it the amount comes wrong…

We be eventually changing it in universe, but any way to do it on repot level not to bring the possitive or negative so they can get the correct sum.

Thanks alot.

BODEV2011 (BOB member since 2010-12-28)

2

If you want all values to be positive then use the ABS() function.

dfoster99 :uk: (BOB member since 2010-11-05)

3

Create a dummy prompt and call it Sign Conv and apply it based on the user’s selection inside a report level varible

Say X is your summed amount, then

varX = x * UserResponse()

This @Prompt you’ll have to define in the universe as decode logic

say Decode(@Prompt('Sign Convention, ‘A’,{‘Negative’,‘Positive’}, mono, constrained),‘Negative’, -1, 1)

jprasanthram :switzerland: (BOB member since 2010-12-10)

4

Thank You guys. I was able to use abs function on reporting level and it worked for me. Thanks

BODEV2011 (BOB member since 2010-12-28)