1 of 1 people found this helpful
I would prefer to see the data in a twbx workbook
but try this
if ifnull( FLOAT(RIGHT([Subscription Type Code],4))/100,0) =0 then (Order total) else FLOAT(RIGHT([Subscription Type Code],4))/100 end
If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution. Thank you.