Hello,
Please, help me to sovle an issue!
I have the following report
-
CHAR | Quant | Amnt | Tariff |
-
|
Char_1 | 100 | 200 | 200 |
Char_2 | 150 | 300 | 200 |
Char_3 | | | |
... | ... | ... | ... |
Char_N | 120 | 240 | 200 |
-
KF "Tariff" is calculated KF and equals "Amnt"/"Quant".
But in some cases mentioned values are absent (in case of Char_3). Nevertheless, I've to calculate or just to display this value for Char_3 as well.
Note, that value of tariff is the same for all CHARs.
In other words, I've to get the following report.
-
CHAR | Quant | Amnt | Tariff |
-
|
Char_1 | 100 | 200 | 200 |
Char_2 | 150 | 300 | 200 |
Char_3 | | | 200 |
... | ... | ... | ... |
Char_N | 120 | 240 | 200 |
-
Thanks in advance.
Hi,
You have tariff = Amount /Quan. Well, if you do not have these values you still should show the tariff. Do you mean to say that tariff is same (200) everytime?
If it is same everytime, you can hide the existing Tariff column and in a new formula you can write the formula like this.
tariff equal to 0, then 200 else tariff.
(tariff = 0)*200+tariff.
This should solve your problem. else think of cell dfinitions if you have 2 structures in place.
Hope this helps you...
Add a comment