Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
manasvi_naikdhure
Contributor II
Contributor II

Converting Set analysis in Backend script

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.

 

Labels (1)
1 Reply
mruehl
Partner - Specialist
Partner - Specialist

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