bo Webi report

[Former Member]

hi Experts,

I have Accepted/Rejected qty in the same "dimension field"

In webi report i want to get only "Accepted" qty alone not the rejected one.

whats the formula to get the result which i want.

[Former Member · Accepted solution]

Hi Maya,

If your situation s both Accepted/Rejected values s depend on quantity.

1.Create Variable

2.Use the formula which Mark mentioned

=[Quantity] Where ([Accepted / Rejected]="Acc")

3.U can use If else control Statement .

Try this,If not let me know

[Former Member]

What do you have in terms of data population?

If you have that object that shows Accepted or Rejected as values and a separate Quantity object then use

=[Quantity] Where ([Accepted / Rejected]="Accepted")

If you have something else then you'll need to give us examples of what is in the field so that we can help you.

[former_member211235]

Apply filter on the block.

Rightclick on block->Add Filter->Select Accepted/Rejected Dimension-> Not in List-> Rejected.

Grtz

-Anila

[Former Member]

Is the dimension field having the two quantities concatenated? Can you show sample value of what comes when you drag the dimension?

-Ankush

[amitrathi239]

Use substr function to get the  "Accepted" value.

=Substr([object];1;8)