Qlik Sense Function set

[PASHA]

Hi,

Greetings,

  Can any one help to short out this formula from given file.

a*b/c

Thanks.

[Channa]

where u wan to add new measure

[PASHA]

In second table or first

[Channa]

=(Sum(DEBIT)*Sum(NETAMT))/sum(total NETAMT)

[PASHA]

I wan to tale sum(Debit) of only one reference site 001-COO

[Channa]

=(Sum({<[REFERENCE_SITE-SITESHORTCODE]={'001-COO'}>} DEBIT)*Sum(NETAMT))/sum(total NETAMT)

[PASHA]

Zero value reflecting

[Channa]

how much you getting  for below

Sum({<[REFERENCE_SITE-SITESHORTCODE]={'001-COO'}>} DEBIT)

[PASHA]

FOR THIS FORMULA

Sum({<[REFERENCE_SITE-SITESHORTCODE]={'001-COO'}>} DEBIT)

[Channa]

Sum({<[REFERENCE_SITE-SITESHORTCODE]={'001-COO'}>} DEBIT)

i dont know ur DB details

we need to add column name in place of "[REFERENCE_SITE-SITESHORTCODE]"

and column text in place of 001-COO