OTBI Formula Help
SummaryFormula help for custom columns
I want to add a couple of custom columns to my OTBI analysis which have formulas in them and I was wondering if someone could help with how I phrase the formulas. I have written them in excel language below. Any help would be very much appreciated. It would also be good to know if they aren't possible.
=IF(Column A="ABC",Column B,Column C) - both columns B & C are numeric
=COLUMN A&" / "&COLUMN D - I want to combine the info from two columns to make a mapping