About set analysis

[nareshthavidishetty]

Can any one give the right set analysis for the below expression

=if(Metric=APPROVEDNOTUSED,sum({<RUNTIME={"=max(RUNTIME)"}>}APPROVEDNOTUSED))

[arulsettu]

try this

sum({<RUNTIME={"=max(RUNTIME)"},Metric={'APPROVEDNOTUSED'}>}APPROVEDNOTUSED)

[effinty2112]

Hi Naresh,

Try:

=if(Metric=APPROVEDNOTUSED,sum({<RUNTIME={$(=max(RUNTIME))}>}APPROVEDNOTUSED))

[miguelbraga]

You can try something like this:

sum({<RUNTIME={$(=max(RUNTIME))},Metric={'APPROVEDNOTUSED'}>}APPROVEDNOTUSED)

Hope it helps

[Anonymous]

try this:

=sum({<Metric={'APPROVEDNOTUSED'},RUNTIME={'=$(=max(RUNTIME))'}>} APPROVEDNOTUSED))

[Kushal_Chawda]

try this

sum({<RUNTIME={"=max(RUNTIME)"}>}if(Metric='APPROVEDNOTUSED',APPROVEDNOTUSED))

[engishfaque]

Dear Naresh,

Please try this one,

=Sum({<Metric = {'APPROVEDNOTUSED'}, RUNTIME = {'$(=max(RUNTIME))'}>} APPROVEDNOTUSED)

Kind regards,

Ishfaque Ahmed