Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
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
yes sunny its in inherited state and table in different state
so now how can i do this?
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)
its giving values sunny let me test in the morning. thanks for the response.
sounds good