SAP BO Universe formula ref to different tables
I am trying to replace all calculation done at Webi report bring it in to the universe to make it generic and available for any new reports. There are several calculations referencing different tables, for instance two different tables. Table A, Table B
Table A contains forecast1, Table B contains forecast 2 & forecast 2%. There is a calculation Forecast 1 * forecast 2% created at the web query using variables, I would like to create that formula in the universe. I am getting error as incombatile. It does not error out in the webi report calculated at the webi report variables. Why there is a difference? Please advise if there is anything I am missing.