can u correct this set expression?

[balasundaram]

=Count({<FiscalYearNum = {"$(=Max(FiscalYearNum))"},LOSTandFOUND.Status={Withus} >}[LOSTandFOUND.Description of item found]))

above expression intension is i need max year with status is 'withs'...but above expression not working..any one corect my expression

[ajaykumar1]

Try like;

=Count({<FiscalYearNum = {"$(=Max(FiscalYearNum))"},LOSTandFOUND.Status={"Withus"} >}[LOSTandFOUND.Description of item found])

[PrashantSangle]

Hi,

try this,

Count({<FiscalYearNum = {"$(=Max(FiscalYearNum))"},LOSTandFOUND.Status={'Withus'} >}[LOSTandFOUND.Description of item found])

Regards

[balasundaram]

thanks ..its working....

[balasundaram]

thank u

[ajaykumar1]

If its working close the thread.

[balasundaram]

how to add?

This question is Not Answered.(Mark as assumed answered)

balasundaram Sep 6, 2014 10:21 AM

='Total '& Count([Moc.Type  .])+Count(Moc.Type.)

above expression i written in under presentation tab in "TEXT IN CHART" , i am trying to show total count,but i used sum not working

[MarcoWedel]

press

at the answer that solved your problem

thanks

regards

Marco