Custom Query Report For quotation

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