Hi
I want to Sum on conditional basis on string field just like this If SalesTypes = "Ledger" then add Cash in Hand field
or Sum(IIF(Fields.SalesType=="Ledger",Field.Cashinhand,0)))
So please help me out I have read so many article but didn't find any solution.
I want to Sum on conditional basis on string field just like this If SalesTypes = "Ledger" then add Cash in Hand field
or Sum(IIF(Fields.SalesType=="Ledger",Field.Cashinhand,0)))
So please help me out I have read so many article but didn't find any solution.
1 Answer, 1 is accepted
0
Hello Muhammad,
You should use a single '=' sign. For example:
Sum(IIF(Fields.SalesType = "Ledger", Fields.Cashinhand, 0)) or Sum(Fields.SalesType = "Ledger" ? Fields.Cashinhand : 0)
Regards,
Todor
Progress Telerik
Virtual Classroom, the free self-paced technical training that gets you up to speed with Telerik and Kendo UI products quickly just got a fresh new look + new and improved content including a brand new Blazor course! Check it out at https://learn.telerik.com/.