error in expression

[bushpalaamarnat]

Hi All,

I have created this expression and in the chart it is giving desired output. how ever in the expression pop up window, it say's errors in expression. What am i missing?

could you help.

SFB

NUM(SUM({<SNAPSHOT_DATE = {'$(=DATE(max([SNAPSHOT_DATE]),'MM-YYYY'))'}, CALCULATION_TYPE = {'SFB'}>}[FC: VALUE ERROR]) / SUM({<SNAPSHOT_DATE = {'$(=DATE(max([SNAPSHOT_DATE]),'MM-YYYY'))'}, CALCULATION_TYPE = {'SFB'}>}[ACTUAL VALUE]), '##.00%')

SFA

=NUM(IF(SUM({<SNAPSHOT_DATE = {'$(=DATE(max([SNAPSHOT_DATE]),'MM-YYYY'))'}, CALCULATION_TYPE = {'SFA'}>}[FC: VALUE ERROR]) / SUM({<SNAPSHOT_DATE = {'$(=DATE(max([SNAPSHOT_DATE]),'MM-YYYY'))'}, CALCULATION_TYPE = {'SFA'}>}[ACTUAL VALUE]) > 1, 0,

IF(SUM({<SNAPSHOT_DATE = {'$(=DATE(max([SNAPSHOT_DATE]),'MM-YYYY'))'}, CALCULATION_TYPE = {'SFA'}>}[FC: VOLUME]) * SUM({<SNAPSHOT_DATE = {'$(=DATE(max([SNAPSHOT_DATE]),'MM-YYYY'))'}, CALCULATION_TYPE = {'SFA'}>}[ACTUAL VOLUME]) <= 0, 0,

1-(SUM({<SNAPSHOT_DATE = {'$(=DATE(max([SNAPSHOT_DATE]),'MM-YYYY'))'}, CALCULATION_TYPE = {'SFA'}>}[FC: VALUE ERROR]) / SUM({<SNAPSHOT_DATE = {'$(=DATE(max([SNAPSHOT_DATE]),'MM-YYYY'))'}, CALCULATION_TYPE = {'SFA'}>}[ACTUAL VALUE])))), '##.00%')

[tresesco · Accepted solution]

Try replacing the single quotes with double for like:

NUM(SUM({<SNAPSHOT_DATE = {"$(=DATE(max([SNAPSHOT_DATE]),'MM-YYYY'))"},....

Note: keep the single quotes used for date or number formatting