Display sales data as per VBUP.GBSTA

[geam1988]

Hallo i have following expressions,

   if(_CURRENCY='EUR' , num(sum(VBAP.NETWR_EUR), '#.##0,00€'),num(sum(VBAP.NETWR_USD), '#.##0,00 Usd') )

for the expressions i have variable   $(vED)

now i want to display the result as per VBUP.GBSTA = 'A','B' . i do not want to show VBUP.GBSTA = C.

I used following expressions

SUM ({< VBUP.GBSTA = {'A','B'} >} $(vED))

  Sum ( {< VBUP.GBSTA = {'A','B'} >} if(_CURRENCY='EUR',num(sum(VBAP.NETWR_EUR), '#.##0,00€'),num(sum(VBAP.NETWR_USD), '#.##0,00 Usd'))  )

but it is not working ...  looking for suggestion...

[balabhaskarqlik · Accepted solution]

May be this one:

If(_Currency = 'EUR',  num(Sum ({< VBUP.GBSTA = {'A','B'} >}VBAP.NETWR_EUR),'#.##0,00€') ,

                                num(Sum ({< VBUP.GBSTA = {'A','B'} >}VBAP.NETWR_USD),'#.##0,00 Usd')

   )

[Peter_Cammaert]

What do you mean by "...but it is not working"? There could be a 100 reasons for SAP stuff to fail.

Are you getting blanks? Null value results? Wrong value results? No results at all? Does your computer crash?

[geam1988]

No value at all     

[Peter_Cammaert]

Do you have a correct link between VBUP and VBAP?

Please post a (complete) screenshot of the Table Viewer. In QV Desktop, press Ctrl-T and use the Export Image button at the left side of the toolbar.

[geam1988]

with this formula i  got the result,

If(_Currency = 'EUR',  num(Sum ({< VBUP.GBSTA = {'A','B'} >}VBAP.NETWR_EUR),'#.##0,00€') ,

                                num(Sum ({< VBUP.GBSTA = {'A','B'} >}VBAP.NETWR_USD),'#.##0,00 Usd')

   )

[balabhaskarqlik]

If you got the result, Make it as Answered & please close this thread.