# Qlik Deployment Framework

This group hosts information related to the Qlik Deployment Framework (QDF). Providing best practices, libraries and utilities that facilitate the recommended setup and management of QlikView or Qlik Sense environments. An understanding of the Qlik platform is recommended before joining this group. Download QDF and documentation here: https://github.com/QlikDeploymentFramework/Qlik-Deployment-Framework/releases

Highlighted Not applicable

## Division formula issue

Hello,

I'm currently still learning about Qlikview but what seemed to be a simple formula turned out to be an issue for me.

I'm trying to calculate the rate of two sum formulas.

My two formulas, sum(A) and sum(B), are able to output data. However, when I want to divide them, my straight table outputs 0.

The formula I have is: Div(sum(A),sum(B)).

Any help would be appreciated. Thank you in advance!

1 Solution

Accepted Solutions MVP

## Re: Division formula issue

See if the Num function helps:

Num(Sum(A)/Sum(B), '##.00000000')

8 Replies MVP

## Re: Division formula issue

May be try one of these:

Sum(A)/Sum(B)

or

Sum(A/B) MVP

## Re: Division formula issue

did you try?

sum(A) / sum(B) Not applicable

## Re: Division formula issue

Yes, and the output is still 0 MVP

## Re: Division formula issue

In addition, Div function outputs a integer so if your Sum(A) < Sum(B) (both positive numbers) you will see 0

QlikView ‒ Div - script and chart function MVP

## Re: Division formula issue MVP

## Re: Division formula issue

See if the Num function helps:

Num(Sum(A)/Sum(B), '##.00000000') Not applicable

## Re: Division formula issue

Thank you, this worked perfectly! MVP

## Re: Division formula issue

Awesome , glad it did