Report Crashes when calculating percentage variance of two columns.
Good morning Yellowfin team,
The problem I have is that my report crashes and submits an error message indicating that something is wrong with the SQL. The problem occurs only when I try to calculate a % variance of two columns (percentage change between two columns to be more precise).
I am using calculated fields in order to achieve this, the formula I am using is as follows:
- (Col 2 - Col 1)/Col 1
The odd thing is however, it works just fine with certain data while with others it does not (my previously created Reports work just fine for instance, however, not when I copy it and filter to a different region).
I also concluded that it is not a matter of the View. Any idea how this could be fixed?
The last thing I'd like to mention, this happens only with Calculated Fields, if I do an advanced function and calculate the % difference of two columns, the report works just fine.
I would be grateful for any advice on how to proceed with that problem.
This is the error I receive: