Need to optimize the set Analysis in load script

[krishnagutha1294]

Hi All,

I am facing an issue  that while opening the sheet the calculation taking too long  I am having below expression in measure 

(sum(Targeted_Qty1) -

(sum(aggr(

if(sum("Targeted_Qty1") - sum("Actual_Qty1") >0,
sum({<[%Flag_IsThisDate]={1}>}"Targeted_Qty1")-sum({<[%Flag_IsThisDate]={1}>}"Actual_Qty1"),
sum({<[%Flag_IsThisDate]={1}>}"Actual_Qty1") - sum({<[%Flag_IsThisDate]={1}>}"Targeted_Qty1")
,)



,Week_Start,Segment,Plant_Description,PLATFORM,SAP_Item_Nbr)) )) / sum(Targeted_Qty1)

Is any possibility to write these condition in load script.

Thank you in advance!!

Thanks,

Krishna

[krishnagutha1294]

Hi all,

Please help me to find the solution for above question?

Thanks,

Krishna