I am trying to create a table calculation to group bunch of different records using if statement. For example I have two different values for a field ‘default’ and ‘Default’ and I wrote a formula as follows:
if field=‘default’ then return ‘Default’. When I ran the data it returned two values for ‘Default’ instead of aggregating values. Not sure if i am missing something but I would really appreciate any help with this.