Expression issue

[Raju_Tadepally]

Dear Friends ,

I have created a small app, which collects data for Hostel Check in .
if there is any damage to any items inside the room , there will be a charge to be debited.

i wrote a sum expression as below :

sum(

{

if([_thisrow].[Room Light]=“Damaged”,5,0),

if([_thisrow].[Fans]=“Damaged”,10,0),

if([_thisrow].[Switches]=“Damaged”,10,0),

if([_thisrow].[Mosquito Net]=“Damaged”,30,0),

if([_thisrow].[Dari]=“Damaged”,10,0),

if([_thisrow].[Bucket]=“Damaged”,30,0),

if([_thisrow].[Dustbin]=“Damaged”,10,0),

if([_thisrow].[Broom]=“Damaged”,30,0),

if([_thisrow].[Dust Pan]=“Damaged”,10,0),

if([_thisrow].[Door Mat]=“Damaged”,10,0),

}

)
i could not get the desired sum in the designated column .
can any one help in correcting my expression?

Thanks in Advance.
Raju

[1minManager]

Hi @Raju_Tadepally

Assusming your adding the damage together:

IF([Room Light]=“Damaged”,5,0)
+
IF([Fans]=“Damaged”,10,0)
…

Simon@1minManager.com

[Raju_Tadepally]

Thanks @Simon Robinson,

Yes i have created a form , in which it is asked whether the items are good or damaged. if it is reported to be damaged then , the fee is levied.
the function need to carry the sum of all such damages in column called “Total debit”

i tried the formula , still it is giving value “0” even when it is indicating damages.

i have used , this row function , is it because of this it is having trouble?
please do guide.