Create If-else Calculation on Text Object

[ksomosera10]

Hi,

I have this Text Object that contains formula of IF-ELSE and aggregating a certain fields.

I can't see any result, just a plain dash(-) on Text Object. Can you help me out here?

Thanks in advance!

[prachisangewar]

Hi Kevin,

Can you share your expression ?

Easier to advise .

Thanks.

[ksomosera10]

Thanks!

Here it is:

=IF(Category = 'ADMIN', NUM(SUM(Hours))

[prachisangewar]

Try this

=if(Category = 'ADMIN',NUM(SUM(Hours),'#,##0'),0)

[Muthu]

Try this.

=sum({$<CATEGORY={ADMIN}>} HOURS)..

If the condition didnt satisfy it will automatically give 0, so there is no need of else condition here.

[sasiparupudi1]

May be try

If (substringcount (GetFieldSelections (Category, ':'))>0,NUM(SUM(Hours),0)

[Anonymous]

Try this:

sum({<Category={'ADMIN'}>}Hours)

[effinty2112 · Accepted solution]

Hi Kevin,

               Rewrite it as

Sum(if(Category = 'ADMIN',Hours))

Sum the if, don't if the sum.

Muthu has already given you an expression that will work and if you're comfortable with set analysis expression use that one. If you have an expression containing an 'if' using a set analysis expression instead will be quicker and when you're used to the syntax will be easier to read.

Cheers

Andrew