topic Re: Help With Script ,sum of Distinct Charge in Reporting Service & Alerting

Help With Script ,sum of Distinct Charge

sivavasam — Fri, 15 Nov 2024 21:16:29 GMT

If extra person in room is child then charge is zero and remaining adult in room number charge should change to zero ,i need Sum(aggr(sum(distinct(charge )),room number . as required 2nd table

Re: Help With Script ,sum of Distinct Charge

rubenmarin — Mon, 13 Nov 2023 08:26:38 GMT

Hi, I think the expression could be something like: Sum(Aggr(IF(Index(Concat(TOTAL <ROOM> AC),'CHILD'),0,Sum(DISTINCT CHARGE)),ROOM))

Maybe it need to add the condition for extra person.

For a room charge, it will be better to have it precalculated in script so the expression in the front end will be easier and give better performance.

Re: Help With Script ,sum of Distinct Charge

sivavasam — Mon, 13 Nov 2023 08:36:43 GMT

Any script level suggesion

Re: Help With Script ,sum of Distinct Charge

rubenmarin — Mon, 13 Nov 2023 08:44:18 GMT

Too few info. The objective would by to create a table by room (maybe by and id that identifies the reserve) and the charge associated to that reservation (maybe only for the extra person) so you only need a sum of this RoomCharge