Formula on Result row
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.