I made custom Query Report on quotation Doc and i select field called (stage) and filed called (delivered) i need to make filed (delivered) appear only when filed (stage) = 100 and make color background for delivered filed
I doubt this is possible in query report, you might have to create a script report for this. Though you can try mysql CASE statement once.
Thanks for your response
what if we can make in JS on the document it self so delivered field get value when stage to be 100
CASE WHEN stage=100 THEN net ELSE 0 END as "Delivered:Float:100 "