Forum Discussion

RebeccaKnecht__'s avatar
RebeccaKnecht__
Qrew Member
10 months ago

SUmmary Report Formula

I have a field labeled METs. Every record has a different number in there as it goes to the 100th decimal (i.e. 10.25) I want a report that groups them into <8.00 , 8.00-10.00, 10.00-12.00 , and >12....
MarkShnier__You's avatar
MarkShnier__You
Icon for Qrew Legend rankQrew Legend
10 months ago

You would make a new field called say MET Group.

IF(

[MET] < 8, "  <8",

[MET] <= 10, " 8-10",

[MET] <=12, "10-12",

[MET] > 12, "12+")

they will sort alpha so you will need to cheat and add extra spaces in the result to get the sequence correct  



------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------