Van# MFG PART# PartDesc Cost Quantity CallsL24Months NoMoveValue
100 100 ABC KIT 1.25 1 0 ---
I was wondering if there is a solution for above....
What i am trying to do is; if "Calls24Months" is 0 (zero) then multiply Cost and Quantity and have it show within the NoMoreValue column, and if the CallsL24Months is not 0 NoMoveValue would be $0
The Calls24Months is a SUM field calculated by adding 24 separate columns (setup as SMALLINT in my table)
In the sample above i only shown one row; but i actually have over 4500 when i run the complete report
This is what i was trying to use:
[Case WHEN 'CallsL24Months' = '0' THEN round(SUM(iccost*icqty),2) ELSE '0' END as NoMoveValue]