How to add a fix amount ( with out conditions or dynamics) to the value of a field ( with preconditions) , in 1 specific row and column
Hi
I have a pre-set sheet with all the formulas and conditions working fine in Qlick sense.
But.
There was a problem in the integration of sales, and one sale got into the system with a different codification than it should be ( that part cant be fixed, but wont happen again)
So now my report does not take into consideration the amount of those specific 3 sales.
I want to make it simple, so instead of asking the report to integrate those 3 documents numbers, i just want to add a fix amount in the report, in a specific row ( store) and column ( type of sale).
So where it add now 219.274,23 € from the normal documents as it is set i want to add lets say 3000 euros. ( as a fix thing, not by any new equation)
I want it in the spot in yellow. ( see picture below)
Long story short : How can i add a fixed value to the value of a field ( that comes from preset conditions) but only in a certain row and column ( store, type of sale).
The easiest way possible, as its a quick fix, just so the statistics do not drag this difference forever.