IS THE EXPR CORRECT?

[#1]

if(dir=abc,sum(usedspace)/sum({<=only({<dir={'abc'}>},totalspace)),0)

[#2]

Expression is not correct

[its_anandrjs]

No i assume dir holds the abc values then put single quotes for that

if(dir = 'abc', sum( usedspace ) / sum( {<=only( {<dir={'abc'} >} ,totalspace)) , 0 )

[ashfaq_haseeb]

Try like this

if(dir='abc',sum(usedspace)/sum({<=only({<dir={'abc'}>},totalspace)),0)

Regards

ASHFAQ

[alexandros17]

try this:

if(dir='abc',sum(usedspace)/sum({$ <only({<dir={'abc'}>},totalspace)),0)

[#6]

Try this

I think there should not b comma (,) before totalspace

if(dir=abc,sum(usedspace)/sum({<=only({<dir={'abc'}>} totalspace)),0)

[#7]

Not working

my actual requirements    if dir ='abc'  then output should be sum(usedspace)/850

here 850 is total space  if i go with 850 i am getting correct result that is static but i want as a dynamic

instead of 850 i want write condition .

if i go with simple sum(totalspace) then it is talking entire space ,i dont want like that

if dir =abc then need to calculate related to abc total space  i.e i written like above expression

[ashfaq_haseeb]

Hi,

It doesn't make sense.

Can you come-up with some sample data.

Then what does sum(usedspace) returns?

Regards

ASHFAQ

[rubenmarin]

Hi, maybe:

if(dir='abc',sum(usedspace)/only({<dir={'abc'}>} totalspace),0)