Set Analysis

[Anonymous]

What could be wrong with the following expression:

=Num((Sum({< [Date Dispensed] = {'>=$(=Date('2013-09-01'))<=$(=Date('2014-08-31'))', [New Product Indicator]={'YES'} >} [MedAid Amount] + [Shortfall])), '$##,##0.00') 

Regards

[swuehl · Accepted solution]

You are missing a curly bracket } and probably the sequence of single quotes will not be parsed correctly by QV.

Use a combination of double and single quotes instead.

=Num((Sum({< [Date Dispensed] = {">=$(=Date('2013-09-01'))<=$(=Date('2014-08-31'))"}, [New Product Indicator]={'YES'} >} [MedAid Amount] + [Shortfall])), '$##,##0.00')

Then take care that the default date format matches the format of [Date Dispensed] and that your default number separators are matching your num() format code. If in doubt, specify the Date() format code and the num() separators explicitely.

[maxgro]

=Num(

(Sum({<[Date Dispensed]={">=$(=Date('2013-09-01'))<=$(=Date('2014-08-31'))"}, [New Product Indicator]={YES}>}

[MedAid Amount] + [Shortfall])), '$##,##0.00')

[Anonymous]

Thank you will check

[Anonymous]

Thank you will advise accordingly