cancel
Showing results for 
Search instead for 
Did you mean: 

How to calculate planned tariff

Former Member
0 Kudos
236

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.

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

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...

Former Member
0 Kudos

Hello,

Unfortunately, tariff is not the same everytime.

This value is calculated every time when report runs.

Value is the same for ALL CHARs but not everytime!

Former Member
0 Kudos

Hi,

Remove that Cal KF and make a New Formula and "Traiff"

and in Formual builder place

=amount/quant

Andthen run the report.

rgds,

San!

Former Member
0 Kudos

... and I'd like to add some information regarding this issue.

We have the following report

-


CHAR | QuantP | AmntP | Tariff | QuantF | AmntF |

-


|

Char_1 | 100 | 200 | 200 | 120 | 240 |

Char_2 | 150 | 300 | 200 | 130 | 260 |

Char_3 | | | | 150 | 300 |

... | ... | ... | ... | ... | ... |

Char_N | 120 | 240 | 200 | 210 | 420 |

-


I have to calculate AmntF using planned tariff, which is calculated as AmntP/QuantP.

Planned KFs for Char_3 are absent.

Note, that calculated tariff is the same for all CHARs.

I tried to calculate this tariff using the following fromula:

SUMCT AmntP / SUMCT QuantP, but as result got 'X'.

Do you have any ideas to solve this issue?