6 Replies Latest reply: Feb 9, 2017 2:17 AM by Gowthamatnaik Basangi

# Calculation problem in Counts

Hi Buddies,

For example:

if i do sum(total field) i'm getting total sum but i'm expecting sum by year wise. please help me out. Thanks in advance.

 FiscalYear Service Type Field count(total field) Expectaion FY13 Type3 13 239 38 FY13 Type4 25 239 38 FY14 Type3 29 239 71 FY14 Type4 42 239 71 FY15 Type1 1 239 130 FY15 Type2 5 239 130 FY15 Type3 68 239 130 FY15 Type4 56 239 130
• ###### Re: Calculation problem in Counts

Count ( total <FiscalYear> field)

Sum ( total <FiscalYear> field)

• ###### Re: Calculation problem in Counts

Hi Vineeth,

• ###### Re: Calculation problem in Counts

Use sum (total <FiscalYear> field)

On mobile , can't check the app sry

• ###### Re: Calculation problem in Counts

What is field here? Is it an existing expression in your straight table??

Then use

Sum (total <FiscalYear> Aggr (sum (Field),FiscalYear))

did you try the above, sivaprakash.t   , we only need to Aggr() on the dimension we need the total on.

• ###### Re: Calculation problem in Counts

May be this?

sum(aggr(sum(total <FiscalYear> Field),FiscalYear,ServiceType))

• ###### Re: Calculation problem in Counts

try this: