expression for percentage

[manoranjan_d]

=num(sum(AMT)/Sum(totalAMT),'##0%')

in this scenraio i want to avoid the null value in the denominator for the expression , since dept field have some null value. how to avoid the null in expression

[tresesco]

What is your expected output?

[kaushiknsolanki]

Hi,

Find the Attachment.

Regards,

Kaushik Solanki

[Anonymous]

Two options:

1) Restrict AMT null values at ETL/Script level

like

Load

*,

AMT

From Table where AMT<>Null or len(AMT)>0;

2)

Did you try like this?

=num(sum(if(len(AMT)>0,AMT))

/

sum( Total if(len(AMT)>0,AMT))

,'##0%')

[Chanty4u]

try

=num(sum(AMT)/Sum(total  IsNull(AMT)),'##0%')

[tamilarasu]

Hi Manoranjan,

You can try,

=Num(Sum(amount)/Sum(TOTAL If(Len(Trim(dept))>0, amount)),'##0%')

[Anonymous]

Suresh/Chanty,

Does ISnull() work like u mentioned?

I think, it should come with IF(), is it not?

[Chanty4u]

yes Raj.

If(

IsNull(Expr1) = 0 AND IsNull(Expr2) = 0 AND IsNull(Expr3) = 0 ...etc.,

True(),

Null()

)

[Chanty4u]

if not  try

=num(sum(AMT)/Sum(total if(IsNull(dept), AMT) )AMT),'##0%')

[Anil_Babu_Samineni]

=num(sum(AMT)/Sum(total AMT),'##0%')

Is AMT Field is There?

=num(sum({<dept = {'*'} - {'NA'} >} AMT)/Sum(total {<dept = {'*'} - {'NA'} >} AMT),'##0%')

OR Else, Can you let me know what you want to Achieve?