Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
I have a problem when calculating a specific value as following:
count({<field1={"$(=[field1]*3/[field2])>5"}>} field1)
Actually what I want to do is to count all the values that divided to another value from a collumn of the table are greather than 5.
Theoreticaly the logic should be correct but practically I get different results compared with what I expect.
can someone help me here?
Gabriel
I'm thinking now that maybe this is the reason: The fact that there are values that are equal. Applying this filter to them, can be the reason for counting 1k values for example as one.
If this would be, then there is a need for calculating ALL the fields, it doesn't matter if they are distinct or not