Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hi all,
i need to find
i. Total losses when Scenario=Actual
ii . Total losses when Scenario=Plan
iii.Actual as a % of planned
please help me to write quries for that
Thanks in advance
smiley
Hi muni,
did u got the soluation for this ?
regards,
vinod
if( Scenario=Actual, losses)
*********************************************************
if( Scenario=Planl, losses)
***************************************************
or try this
if( Scenario='Actual', losses)
*********************************************************
if( Scenario='Planl', losses)
no yar
can u help me plz...
Thanks in advance
smiley
if(Scenario=Actual,1,Total(Losses))
try this
1)sum(Total {$<Scenario='Actual'}>}losses)
2)sum(Total {$<Scenario='Plan'}>}losses)
3)sum(if(Scenario='Plan',losses))/sum(if(Scenario='Plan',total losses)) or
try this way
sum( {$<Scenario='Plan'}>}losses)/sum(TOTAL<Scenario>losses)
//and for this in presentation tab Fixed to 2 and check on show %
or if you using straight table then simply write
sum(Total {$<Scenario='Plan'}>}losses)
or tick on expression total in expression tab
try this
sum(Total {$<field=>}losses)