Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Oscar101
Contributor
Contributor

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.

 

Thanks is advance!

 

Oscar101_0-1687534766380.png

 

 

 

Labels (1)
0 Replies