Search results for query: *

I made a mistake. Fisheromacse your formula works but {CUST_ORDER_LINE.TRADE_DISC_PERCENT} is % to subtract from the unit price, so to get the correct total need to take (100 - {CUST_ORDER_LINE.TRADE_DISC_PERCENT} * .01) eg. a $197 fixture will be discounted 15% so the selling price is $167.45.

Hi, here is what i want to have happen (If {CUST_ORDER_LINE.UNIT_PRICE} <= {PART.UNIT_PRICE} then [({CUST_ORDER_LINE.UNIT_PRICE} * {CUST_ORDER_LINE.TRADE_DISC_PERCENT}) when {CUST_ORDER_LINE.TRADE_DISC_PERCENT} <> 0 ] else {PART.UNIT_PRICE};) * {RECEIVABLE_LINE.QTY} i am sure it is a syntax...

Hi, I have a report where i would like to have 1 column that will look at 3 fields, (part.fabricated, part.purchased, and part.detail_only) these fields have either a "Y" or "N". What i would like to do is have a formula that says "if part.fabricated = "Y" then "F" else part.purchased ="Y" then...

Awesome, that did the trick! Thank you, You da Man!

OK, thanks for the tip, appreciate it. In addition to the existing criteria, I also want to evaluate all values from {PART.ENGINEERING_MSTR} field except numerals greater than 0. There are numerals, alpha strings and nulls in this field. TIA!

Here is the selection criteria i have : ( ({PART.QTY_IN_DEMAND} <> 0.00) and ({PART.ORDER_POLICY} <> ["D", "E"]) and ({PART.DETAIL_ONLY} = "N") and {PART.ENGINEERING_MSTR} = "Q" ) OR ( ({PART.QTY_IN_DEMAND} <> 0.00) and (({PART.PLANNING_LEADTIME} = 0.00) OR ISNULL({PART.PLANNING_LEADTIME}))...

Thanks a bunch, that worked great. Have a wonderful weekend!

I have a report where i have figured out how to pull the most recent 12 months of part usage, here is the select statement: {INVENTORY_TRANS.PART_ID} like {?PART_ID} and {INVENTORY_TRANS.TYPE} = "O" and {INVENTORY_TRANS.TRANSACTION_DATE} >= dateadd("yyyy", -1, currentdate) and...

Thank you guys alot for the help. I got an acccurate count for 12 months, but i don't know how to write the formula for only 6 months. When i put in: If {INVENTORY_TRANS.TRANSACTION_DATE} >= dateadd("m", -6, currentdate) then {valueField} else 0 i get an alert that {valueField} is not a known...

actually, i don't know what i am talking about cause to get this info on 1 report i would need to pull the data via formulas right? 1 for last 12 months and 1 for last 6 mo. Not use select expert. Sorry for my confusion.

Hi, i know this is noob issue but i need to get transaction info for previous 12 months and previous 6 months with monthly average for each. Here is select expert: {INVENTORY_TRANS.PART_ID} like {?PART_ID} and {INVENTORY_TRANS.TRANSACTION_DATE} >= Date (0, 0, 0) makes sense to me...