Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a tricky table that I hope you can help me with.
The table consists of field that detail completion rate (in %), however, one field contains median age.
I didn't notice this at first and just used the sum function in an expression and it works for my completion rate fields, but it doesn't make sense in the median age field.
I was thinking that I need to add a conditional expression so that it will use the sum function per default but if the field name is median age then I use another way of calculating so I get a good result.
I can't quite figure out how to use a conditional expression or if it is even possible.
I hope it makes sense.
Any Help is appreciated!
Casper
Maybe try this:
if([FieldName]= "Median Age", <Exp for median age>, <default expression>)
Maybe try this:
if([FieldName]= "Median Age", <Exp for median age>, <default expression>)
Hi, thanks for your reply.
Your solution worked when I replaced the "" with ''.
Thanks.