How to get percent of total for the calculated field (referenced field) in the table

Question & Answer
, ,
1

Hi experts

I want to create the percent of total column at the end for “Industry Gross Sales ex-SIP” which is my calculated field.

image
image765×397 44.7 KB

Industry Gross Sales ex-SIP:

sumOver
(
     sum({IND_Gross_Sales}), 
     [{FINTECH_PARTNER}]
)
-
sumOver
(
     sum({Industry SIP Triggered AMT}), 
     [{FINTECH_PARTNER}]
)

Here,IND_Gross_Sales and Industry SIP Triggered AMT are my data fields.

I have created percent of total calc for my data fields (refer Industry SIP Triggered Count (Mix %) in screenshot) with below calculation:

Industry SIP Triggered Count (Mix %):

 percentOfTotal(sum({Industry SIP Triggered Count}), []) * 100

here, Industry SIP Triggered Count is my data field

But when I am doing this for calculated field “Industry Gross Sales ex-SIP”, I am getting the below error:

image
image844×253 46.8 KB

How this can be achieved ?

Best,
Vaibhav

2

Hello @Vaibhav_Patidar

This has to do with your LAC functions. I would recommend checking out this article: