REP-1517: Column 'CF_Amount' reference column 'amount', which has incompatible frequency.
Dear,
I have two queries(Q1 and Q2) in reports. On Q1 query contains amount column and on Q2 query contain amount_1 column.
They are different group and not link. I want to subtract mount column from amount_1 column.Hence I created
the formula column(CF_Amount) outside of two queries, it is compiled successfully. But when I run the report, I got the following error.
REP-1517: Column 'CF_Amount' reference column 'amount', which has incompatible frequency.
REP-1517: Column 'CF_Amount' reference column 'amount_1', which has incompatible frequency.
How to subtract the columns from different queries?
Best Regards,
Htet Htet