problem with Absolute value of measure ...

building reports webintelligence
1

Hi

I have a measure object which has negative values along with positive values. But in the report i need to show only absolute value of the measure. So i have used Abs() function to display. The report has one section. When i take total of the measure using absolue value, the sum is coming fine at section level. I need to display one grand total for the entire report. But when i use the absolue function to display the grand total, the absolute funtion is not working. I am getting the grand total as if there is absolute fuction. Any idea how to do this… :crazy_face:

thanks
Praveen

praveen11k :india: (BOB member since 2006-05-22)

2

What does this mean :!:

.

haider :es: (BOB member since 2005-07-18)

3

Sorry for missing No there…

For example if have mesure values like 1,-2,3,-4,5,6. If i take absolue sum i should get 1+2+3+4+5+6 = 21. I am getting this at section level. At the grand total level i am getting 1-2+3-4+5+6 = 9. I have used Abs(measure) at both the totals. The absolue fuction is not taking effect at grand total level. Hope i am clear now

praveen11k :india: (BOB member since 2006-05-22)

4

Hi Praveen,

Let’s assume the measure you are using has a name “Measure1”.

Now, create another measure variable with it’s value as “Absb[/b]”.

Use this new variable everywhere, i.e. in the body of the report as well as in the sum of section and the grand total. It will work.

Thanks,
Srivatsa

srivatsakr :india: (BOB member since 2007-07-27)

5

Hi Srivatsa

I already tried this. As i mentioned it is working at section total and failing at report grand total.

Praveen

praveen11k :india: (BOB member since 2006-05-22)

6

Since section doesn’t have a grand total unlike break, how are you showing the grand total
Is it in a separate block, if yes are you able to show the details and a total of that

.

haider :es: (BOB member since 2005-07-18)

7

Hi Haider

Yes, i have created another block to just display the grand totals of all my mesures. Find the attached screen shot for more information. Here No actual cash flow is in section. The grand totals are displayed in another block.

Praveen
screen.doc (40.0 KB)

praveen11k :india: (BOB member since 2006-05-22)

8

Do this in second block for grand total

=Sum(Abs([Sales revenue] In ([State];[Year])))

Its an illustration of eFashion universe, replace the state and year dimensions with the ones you have

.

haider :es: (BOB member since 2005-07-18)

9

The problem got solved when used the context operator. Below is the updated formula.

=Sum(Abs([Total Untraced Value] ForEach([Revenue Flow 1];[Revenue Flow 2];[Month Name])))

Thank you all for your ideas… :lol:

praveen11k :india: (BOB member since 2006-05-22)