WebI Formula

building reports webintelligence
1

I have two fields in hard coded report:

=ToNumber(Max([Answer])) Where ([Pseudonym]=“P1: C-I Cost”)
…
…
…
…

and

=Sum([quantity]) Where ([string value]=“Counseling - Individual”)
…
…
…
…

Here for Each [string value] value there is one "ToNumber(Max([Answer])) Where ([Pseudonym]=“P1: C-I Cost”)
"
But i need multiplication of both for each [string value] and finally i need overalll sum.

Thanks in advance.

yogamalaka :us: (BOB member since 2011-06-21)

2

Requirement is not very clear, can you help us with the clean requirement to understand it correctly…?

aniketp :uk: (BOB member since 2007-10-05)