Converting Set analysis in Backend script

manasvi_naikdhure — Fri, 15 Nov 2024 21:04:37 GMT

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.

Re: Converting Set analysis in Backend script

ManuelRühl — Tue, 13 Feb 2024 07:00:59 GMT

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

topic Converting Set analysis in Backend script in App Development

Converting Set analysis in Backend script

Re: Converting Set analysis in Backend script