Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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%')
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
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