Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

QRP Question How to

Status
Not open for further replies.

tambrosi

Programmer
Jun 20, 2013
2
US
Hello,

I am new to using qrp and I need to change/add to this statement.
StrIFF( StrCompare( PricingMethodCd , 'EA' ) , NumberToStrPicture( Price ,'$##,##0.00;($##,##0.0000)' ) , NumberToStrPicture ( Price ,'$##,##0.0000;($##,##0.0000)' ) , NumberToStrPicture( Price , '$##,##0.00;($##,##0.00)' ) ) || ' / ' || PricingMethodCd

I need to use something like an if then statement/condition.

IE: if cust = ' xxxxx'
do this
else
StrIFF( StrCompare( PricingMethodCd , 'EA' ) , NumberToStrPicture( Price ,'$##,##0.00;($##,##0.0000)' ) , NumberToStrPicture ( Price ,'$##,##0.0000;($##,##0.0000)' ) , NumberToStrPicture( Price , '$##,##0.00;($##,##0.00)' ) ) || ' / ' || PricingMethodCd


Any help would be appreciated.
Thanks
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top