Calculation between two count values of different fields

[#1]

Hello community,

I have two statistics boxes, both of them with a value representing the count of a field; let's call these values val1 and val2.

I need to have another value: val3 = val1/val2. Can I have this calculation made somehow, specifying it with some object? Or do I need to make this calculation in my load script and in the database?

Thanks in advance,

Regards,

Ygor

[johnw · Accepted solution]

I assume it's something as simple as making a text box with this expression:

=count(field1)/count(field2)

Or if you want distinct values:

=count(distinct field1)/count(distinct field2)

But I may be misunderstanding the question.

[#3]

Actually, it really is as simple as that!

I thought the text box was just a simple object to add text, I should have explored it further before making silly questions 🙂

Thank you very much for the quick reply!

Regards,

Ygor