Script

[Anonymous]

@rammohanhdvd 

,(CASE WHEN [HLS_Lossess].[Impact Taxonomy]

         IN ('Direct - Insurance Recoveries','Direct - Provision Writeback', 'Direct - Gain', 'Direct - Recoveries')

         AND CAST([HLS_Lossess].[Impact Estimated Amount (Event Currency)] AS FLOAT) >0.0

         THEN CAST([HLS_Lossess].[Impact Estimated Amount (Event Currency)] AS FLOAT)*-1

         ELSE CAST([HLS_Lossess].[Impact Estimated Amount (Event Currency)] AS FLOAT) END)

         AS [Impact Estimated Amount (Event Currency)]

[Anonymous]

@rammohanhdvd 

[rammohanhdvd · Accepted solution]

LOAD IF([HLS_Lossess].[Impact Taxonomy] IN ('Direct - Insurance Recoveries', 'Direct - Provision Writeback', 'Direct - Gain', 'Direct - Recoveries') AND Num([HLS_Lossess].[Impact Estimated Amount (Event Currency)], '#.##') > 0, Num([HLS_Lossess].[Impact Estimated Amount (Event Currency)], '#.##') * -1, Num([HLS_Lossess].[Impact Estimated Amount (Event Currency)], '#.##') ) AS [Impact Estimated Amount (Event Currency)] FROM [your_data_source];