Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Formula calulation in SQ01 ,Queries ,infoset

Hi Gurus

I have a field VBGEL (Document No ) , I name it as REF in short fields.I have created a display field ACTUAL_PR which display qty*st price

After highlighting on the ACTUAL_PR I wrote a formula by going to Edit- change

Short name = ACTUAL_PR

Calculation Formula

INV_QTY * ACT will calculate qty x st price and display the result in ACTUAL_PR.

Condition : REF <> '6' AND REF <> '7' then the value must display else 0 should dislay

i.e I want to write a formula For actual price .

There is a field in the table VBGEL (Shortname colum REF) which starts with 60001242, 600025634,700002523,700005232,82344252,8233252 etc., Now I want the Actual price to display as zero where VBGEL starts with 6* (credit) AND 7* (debit) in my report.

So when I run the report the Actual price = INV_QTY * ACT should shows ' 0 ' value and rest ref starts from 8* etc., should shows the value as it is.

How can I write a formula and what have to written in the condition?

Thanks in advanced

Piroz

Tags:
Former Member
Not what you were looking for? View more on this topic or Ask a question