Is there a way to set Yellowfin to assume NULL=0 and when doing calculations it would display the desire results? For example, I have an entry with NULL cost while Revenue is say 10. Profit for that area in Yellowfin now is 0. Any quick way to make it display the right value?
We suggest using calculated fields that include CASE statements. You can create calculated fields at the view level, and also use virtual tables that will allow you to enter Freehand SQL. More information on those options is here: view level calculated fields and virtual tables.