Formula calulation in SQ01 ,Queries ,infoset
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
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