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
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