How to find Total amount charged for given data which is incremental and cannot be bucketed ?

[shekhar_analyti]

Hi All ,

How to find Total amount charged for from the given data where CONCLAVE_TYPE = Group

Charge for Conclave is 1200 per day per person attended.

Note : And this data gets new rows in every Six Hours .

Example

For UKAB2 : It is attended by only one person and conclave was for only 1 day , so calculation will be

                     1200*1*1 = 1200

For UKAB4 : It is attended by three person and conclave was for only 3 days(25,26,27) , so calculation will be

                     1200*3*3 = 10800

Like wise , my requirement is basically Sum(cHARG

Thanks & Regards

Shekar

[sunny_talwar]

May be something like this

1200*Count(DISTINCT Attended_By)*(Floor(END_TS)-Floor(START_TS) + 1)

[sunny_talwar]

Image and sample attached

[shekhar_analyti]

Sunny Bhai ..Thank for reply ... Actually i wanted an expression for Text Box   , which should display total Charge

[sunny_talwar · Accepted solution]

Try this

Sum(Aggr(1200*Count(DISTINCT Attended_By)*(Floor(END_TS)-Floor(START_TS) + 1), CONCLAVE_ID))