Calculation using virtual columns

[Dave2]

Hi!

I am trying to do a simple calculation in a virtual column using the AppFormula results of two other virtual columns that are outputting a number (via a COUNT expression) as variables, but the result is always “0”. I am trying to divide the results of one virtual column by the other to generate a decimal output. Any ideas on what I’m doing wrong?

[Austin]

Can you validate that the output of these 2 columns you’re dividing are not 0?

[Dave2]

The two columns are generating correct outputs individually, however when I test the third column AppFormula it’s outputting zero, also when displaying in a view. Here is how I have it structured:

Cancellations 30 Days (virtual column): COUNT(FILTER(“Invoice Detail”, AND([_THISROW].[Client Name]=[Client Name], [Invoice Data::Item]=“C/C”, ([Invoice Data::VisitDate] <= TODAY()), ([Invoice Data::VisitDate] >=TODAY()-30))))

Total Appointments: 30 Days (virtual column): COUNT(FILTER(“Invoice Detail”, AND([_THISROW].[Client Name]=[Client Name], ([Invoice Data::VisitDate] <= TODAY()), ([Invoice Data::VisitDate] >=TODAY()-30))))

Fulfilled Appointments: [Total Appointments: 30 Days] - [Cancellations 30 Days]

Attendance Rate: 30 Days: [Fulfilled Appointments] / [Total Appointments: 30 Days]

All the virtual columns up to the last one are calculating correctly.

[Steve]

I divide two numbers and get zero...? Questions

A Number value is an integer, a number with no fractional component. When two Number values are divided, the result will also be a Number value, resulting in the loss of the fractional component that may result from the division. For instance, 5 / 2 gives 2 instead of 2.5. If one or both of the values in the division operation are Decimal values (which have fractional components), the result will be a Decimal value. Multiplying a Number value by a Decimal value produces a Decimal value, so mu…

Fix for expression giving 0% or missing decimal part Tips & Tricks 💡

Trying to divide two numbers to get a percentage but always getting 0? Trying to divide two numbers but losing the numbers after the decimal point? TRY THIS Convert one or both of the values in your division expression to a Decimal value, either by: (1) wrapping the value in the expression with the DECIMAL() function; (2) multiplying the value in the expression by 1.0; or (3) changing the column’s type to Decimal if suitable to the app. FOR EXAMPLE If computing a percentage from two Number co…

[Dave2]

That did it! Thanks for your help.