Converting Set analysis in Backend script

[manasvi_naikdhure]

Hi ,

I have to optimize the UI and for that I have to write all the set analysis in the Backend load script.

How to write below set analysis in the backend script. 

if(Sum(TOTAL<[Actual Payer ID]>{<[Actual Mode Of Payment]={'*CASH*'}>+<[Actual Mode Of Payment]={'*DEMAND DRAFT*'},[Payment Number]={'>0'}>}[Payment Amount])>500000,Sum({<[Actual Mode Of Payment]={'*CASH*'}>+<[Actual Mode Of Payment]={'*DEMAND DRAFT*'}>}[Actual Payment Amount]),null())

Please help.

[mruehl]

The TOTAL qualifier makes it complicated in the script.
I suggest to flag the relevant rows and do the aggregation in the UI:

if(wildmatch([Actual Mode Of Payment],'*DEMAND DRAFT*','*CASH*')>0,1,0) and so on...