function substr in WebI

[Former Member]

Hello Together,

System Information: BO 4.0 SP 2 Patch 10

I created a report with webi based on a SAP BEx query. The report is working well but if I insert the following formula the whole data disappears: substr (sales rep; 5;10)

It does not matter if I insert the formula to a new column directly or with the help of a variable, After I confirm the formula the sheet is empty.

Can anybody help?

Thanks and kind regards,

Jule

[Former Member]

Hi Juliane,

When you say whole data disappears, is it just the column (with formula) for which data disappears or the whole report get affected?

What is the datatype of [Sales Rep] object? Character or Number? Substr will only work with Character type

If Number then typecast it to Char and check.

if Character, then use Length() and check the number of characters whether they are more or less than 5.

Regards,

Yuvraj

[former_member652821]

Hi ,

Are you using =substr(sales rep;5;10) ?

[Former Member]

Yes, I use the correct formula but everything disappears.

[Former Member]

Thanks. Create such a important query base on your sample