Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
I have a straight table(Sample attached) where i am calculating value of a column(Averted Cost) using the below formula:
REMDAYS*SUM(CX_MINUTES* CX_RATE)
the field REMDAYS is a number which is calculated using a Load statement in the editor(This number is the difference between 2 dates and varies per account).
I want to create another straight table, which will calculate the Sum of Averted Loss on a monthly basis. How can i do that?
I am able to get the SUM of Customer Cost as this is taken from the DB directly, but as the Averted Cost is calculated using a function, how can we use that?
Thanks
Taher
Hi Taher, to do a table eith month as dimension (and no customer) you can add an aggr() to calculate the value per customer, and sum the value of all customers:
Sum(Aggr(REMDAYS*SUM(CX_MINUTES* CX_RATE), MonthField, CustomerField))
Could not find any sample attached. Can you re upload please?
Hi Taher, to do a table eith month as dimension (and no customer) you can add an aggr() to calculate the value per customer, and sum the value of all customers:
Sum(Aggr(REMDAYS*SUM(CX_MINUTES* CX_RATE), MonthField, CustomerField))
He Vishwarath,
I attached the image instead.
Hi Ruben,
This worked. Thanks a lot.
Taher