Hi. I have 2 calculated fields that I derive it myself. I want to divide one by another. When I’m creating a new calculated field (FNAB) with this syntax, it shows nothing in the pivot table {Food & Non-Alcoholic Expenditure} / {Private Consumption Expenditure} * 100 [image] Could anyone help wi…

Sorry, I believe my previous response was a bit confusing. Let me break this down into steps. Step 1: Food & Non-Alcoholic Beverages = sumOver(sum(ifelse({DataSeries} = “Food & Non-Alcoholic Expenditure”, {Value}, NULL)),[TimePeriod]) Step 2: Private Consumption Expenditure = sumOver(sum(ifelse({D…

Hi duncan, the 2 calculated fields that I am using is defined as ifelse({DataSeries} = "Private Consumption Expenditure", {Value}, NULL) ifelse({DataSeries} = "Food & Non-Alcoholic Expenditure", {Value}, NULL)

Hi @junyangggggg , Can you try sumOver with partition of TimePeriod for the nested calculated fields? I presume, since the aggregation is not done at TimePeriod level, the calculation is getting executed at record level and for each record either of the nested calculated field is returning NULL, re…

Hi @prantika_sinha , thanks for replying! I’ve tried sumOver(sum({Food & Non-Alcoholic Beverages})/sum({Private Consumption Expenditure}), [TimePeriod]) but the values are still NULL for FNAB

thanks @prantika_sinha . It works!!

Dividing 2 calculated fields?

Q&A

WLS-D June 14, 2024, 3:01pm 2

Hi @junyangggggg,
I’m curious to see what the 2 calculated fields are that you’re using in this, could you share? It may work best if you use Arena to create a sample dashboard so that we can better assist.

Thank you!

Topic		Replies	Views
Dividing 2 columns on a pivot table Q&A quick-sight , calculations	4	1980	May 10, 2023
Calculate new filed nased based Visua1 filed and Visual2 filed Q&A developer , quick-sight , dashboard-embed	1	18	May 12, 2025
Calculated Field to divide sum values Q&A analysis , quick-sight , calculations	2	1296	September 22, 2023
How to divide two aggregated field value pivot table - quicksight during expand or collapse? Q&A quick-sight , calculations	10	2212	August 11, 2023
Divide 2 calculated fields in Quick Sight derived from same column xyz Q&A analysis , quick-sight , calculations	11	2667	September 26, 2023

Dividing 2 calculated fields?

Related topics