how to use

[soniasweety]

Hi all,

Miguel Angel Baeyens de Arce

Bala Bhaskar

i want to use variable in alternate state expreession   below i tried but no luck   how to use?

=Sum({<[Name] -= {"=len(trim([Name]))=0"},[L1]=$::[L1],[SRn]=$::[SRn],FormatId=$::FormatId>}[Amount])
/$(vFormatId)

variable  is not workibng  here    but when i hardcode the value  its working   

if i use variable data not showing anything

//1000000
//$(vFormatId)
//only({<FormatId=$::FormatId>}FormatId)

variable:  vFormatId=FormatId

format id is field  and having values  1000000,1000

[soniasweety]

yes sunny   its in inherited state  and  table in different state

so now how can i do this?

[sunny_talwar · Accepted solution]

If you make selection in FormatId in inherited state, then may be try this

=Sum({<[Name] -= {"=len(trim([Name]))=0"}, [L1] = $::[L1], [SRn] = $::[SRn], FormatId = $::FormatId>}[Amount])/Only({$} FormatId)

[soniasweety]

its giving values sunny let me test in the morning.  thanks for the response.

[sunny_talwar]

sounds good