Bex query designer the blank space

[balac]

Bex query designer the blank space fill # is mandatory one, but i don't fill #.in the report i need blank field only

Message was edited by: Jason Lax > Moved to right space, updated title

[former_member195433]

I have a similar question i want to create a formula with handling "#".

how can i acheive this in bex , as we dont have if and else statements i am using Boolean functions to achieve this  , but i cant enter "#' or cant use a blank ""

( Formula variable ==1001) *KF1+( Formula variable== 5002) * KF2+  (Formula variable =="#")*KF3

Note : Formula variable is by processing type - replacement path with Char info object.

[former_member194898]

Hi,

Did you think about VBA code changing it.

http://scn.sap.com/thread/1040239

http://scn.sap.com/thread/451819

Hope this helps.

Leszek

[balac]

thanks

[KodandaPani_KV]

Hi,

# means it is the blank vlaue.

check the MP/CUBE in the LISTCUBE (TXCODE)

if you want blank values in report level you will get # values

if don't want the # values  you can restrict the at the designer level.

open the query designer -> open the qeury -> select the object -> right click -> select the restrict with exclude function.

Thanks,

Phani.

[balac]

thanks

[sander_vanwilligen]

Hi Bala,

The hash sign (#) represents an initial (blank) value in BW and BEx Query Designer. That is how it is designed.

Best regards,

Sander