Hi Experts,
How to write the Sub-query for the Calculation View -using SQL Script.
Below mentioned Sub-query is not working in Calculation View. Is there any alternative method Exist for this Query:
((SELECT SUM((case when upper(t4."staType") =-100 then T4."TaxSum" else 0 end) FROM PCH4 T4 WHERE T4."DocEntry"=T0."DocEntry" ),0)) "CGST_Amt"
Thanks in Advance..