how to calculate totals

Swathi — Fri, 15 Nov 2024 20:58:18 GMT

i have different types and countries are there , i need totals for each type and countries, some places need total few rows like that

in the above screenshot we can see i have group, country, type fields are there, for group is Europe, i need all totals Europe group. as group europe i have 3 types Totals are there one is

1.TOTAL

2.TOTAL Power

3.TOTAL Gas

TOTAL means summ of all {<Year = {$(vYearSelect)}> } $(vPortfolioValue_mCHF), irrespetive of which type it is. it will summ of all rows for Group='Europe'

TOTAL Power means sum of all {<Year = {$(vYearSelect)}> } $(vPortfolioValue_mCHF), where Group='Europe' and Type ='Power'

i tried below formula, but iam not any getting any data it is 0.0 as seen screenshot.

Pick(SrNo,

if(GetFieldSelections (Group)='Europe',
if(Country= 'TOTAL',
{<Year = {$(vYearSelect)}> } $(vPortfolioValue_mCHF),
if(Country='TOTAL Power',
{<Year={$(vYearSelect)},Group={'Europe'},Type={'Power'}>} $(vPortfolioValue_mCHF),
if(Country='TOTAL Gas',
{<Year={$(vYearSelect)},Group={'Europe'},Type={'Natgas'}>} $(vPortfolioValue_mCHF)

)
)

)

),{<Year={$(vYearSelect)},Group={'Europe'}>} $(vPortfolioValue_mCHF))

variable formula is

$(vPortfolioValue_mCHF),=

num(Sum(((ConsumptionForecast
*
(HedgeableCapacitiesTotal
*
If(ConsumptionForecast<>0,
If(AveragePriceUnhedgedFWD <> 0 and AveragePriceUnhedgedFWD <> '',
AveragePriceUnhedgedFWD - [FinancialImpactP&LMtminK] * 1000 / ConsumptionForecast,
MarketPrices - [FinancialImpactP&LMtminK] * 1000 / ConsumptionForecast),0)))
/HedgeableCapacitiesTotal)

/(1*1000000)) * Sum(Blended),'#0.0')

Kindly help to get these it's very urgent and important.

Re: how to calculate totals

Anil_Babu_Samineni — Fri, 24 May 2024 01:26:57 GMT

We recommend to start with sample dummy application if your data is so sensitive and send it to us the QVF to look.

topic how to calculate totals in App Development

how to calculate totals

Re: how to calculate totals