divide operation -Please Help

[#1]

Hi together,

please look at my attached example qvw file.

I have three fields "a", "b" and "complete". At the beginning i have the field "complete" with the sum of the fileds "b". In this case it is

complete = sum ( total ( b ) ) ; like 20+20+30+30+30+40+50 = 220. ok, so far so good !

Now If i choice at the field "a" the option "bmw", then they select the assigned value of 20 from field "b". When i do that, the "complete" field also changed to the assigned value "20".

But my goal is, to divide the sum 220 with the selected value 20. So that i get the value 10.

How can i do that. Thank you !

[pover · Accepted solution]

You have to ignore the selection of "a" with set analysis:

= sum ( {$<a=>} total (b) )

Regards.

[#3]

Hi Karl Pover,

Thank you very much !

Best Regards,