IF statement not getting result

[anonymous]

Hello All, I have this expression:
IF([Category]=“Salary”,
Sum(Select(Salary Cost[Sub Total],[Company]=[_THISROW].[Company]))*30,“”)
the column [Category] is a ref type column.

Here below, the "Cost has 0 value. if remove the If statement the answer is correct. what is wrong here?

thanks

[Suvrutt_Gurjar]

@Mario_Moncada

the column [Category] is a ref type column.

If understanding of your requirement is correct, please try

IF([Category].[Label Name of the referenced or the parent table]=“Salary”,
Sum(Select(Salary Cost[Sub Total],[Company]=[_THISROW].[Company]))*30,“”)

Since [Category] is referenced column, in the form it displays the label of the referenced table, but its underlying value is the referenced or the parent table’s key. So please retrieve that label through dereference expression and then compare with the [Category] type.

Dereference expressions - AppSheet Help

Add row labels - AppSheet Help

[anonymous]

Thanks, Suvrutt

[Suvrutt_Gurjar]

You are welcome.