Formula on Result row

[Former Member]

Hi,

I have query where I have created two buckets using 2 formulas, say F1(>50%) & F2(<=50%). There is 3rd formula F3=F1+F2.

Now, for F1, F2, F3, in "Calculation" tab, Calculate Result as set to Total.

So for F1 & F2 in result row I'm getting total, say 10 & 20.

Thus, F3 is 30.

Now, I need to define one more formula F4 = F1 / F3 * 100 & in result row I'm expecting 10 / 30 *100 but this is not working out.

While calculating result value for F4, it is not taking into consideration the setting applied on F1 & F3 to calculate result as total.

I tried same with calculated KFs insted of Formula & also aggregation as Total but no change.

Please suggest me solution if u have faced such issue.

Regards,

Pallavi

[Former Member]

Dear

Check the properties of that formula. In "Calculate result as" menu you will get proper clue.

Regds,

Sachin J

[purvang_zinzuwadia]

hi,

why dont you try to make formula simple by making below changes,

F3=F1+F2,

not working --> F4=F1 / F3 * 100

try this --> F4 = F1 / (F1 + F2) * 100

hope this helps,

Purvang

[Former Member]

Hi,

Create a formula for result row as per your calculation.

Give that formula's heading as Result.

Hide all the result rows and columns in the report by using query property.

Vivek

[Former Member]

Hi,

Try to create formula for the result calculation.

Give the heading for that formula as Result.

Then in the characteristic and keyfigure properties choose Result Rows -> Always suppress.

Vivek