Expression

[#1]

Hi i want to get the sum for the selected  fields only , and  iam using the Below formula in the expression , which seems to be ok ,

But iam not getting any output .

Can someone tell me what change i need to do

The formula is

(if(match([Tab Description],'Erection Contract','Sales Contract','Works Contract'),sum({$<FiscalYear={$(=MAX(FiscalYear))}>}[Contract Value net])))

[arulsettu]

try like this

sum({<[Tab Description] ={'Works Contract', 'Sales Contract','Erection Contract'},$<[Fiscal Year]={$(=Max([Fiscal Year]))},[Fiscal Period]={"<=$(=max([Fiscal Period]))"},[Fiscal Month]=>}[Contract Value net]))

[sunny_talwar · Accepted solution]

Maybe this will work:

=Sum({$<FiscalYear={$(=MAX(FiscalYear))}, [Tab Description] = {'Erection Contract','Sales Contract','Works Contract'}>} [Contract Value net])))

Best,

S

[rubenmarin]

Hi, where are you using this expression?, it can work on a chart where [Tab Description] is a dimension or if only one value of [Tab Description] is selected, if there is no such dimension or selection maybe is returning more than one value for [Tab Description] and in expression is translated as Null().