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.
Dear @nabinhait
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
any idea
Thanks @nabinhait
working now
CASE WHEN stage=100 THEN net ELSE 0 END as "Delivered:Float:100 "
1 Like