Skip to Content
0
Jun 30, 2020 at 04:15 AM

SubQuery in Calculation View for modeling

319 Views Last edit Jun 30, 2020 at 04:19 AM 3 rev

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..