Expression Total

[#1]

Hi All

For some reason, When I use the expression total for the below IF Statement, it seems to display as true even though we are in Nov. - NUM(month(today())) is definitely greater than data in January - Please see attached for illustration.

Expression

=IF(Month_PurNum<=NUM(month(today())),SUM(JanValue_Pur),SUM(Jan_P))

[#2]

It seems like your problem is that for the row you are having issues with has no Month_PurNum so your formula does not return the correct results.

Try this. It should now return a 0 because it does not fit into either category.

=IF(Month_PurNum<=NUM(month(today())),SUM(JanValue_Pur),

IF(Month_PurNum>NUM(month(today())),SUM(Jan_P)))

[#3]

It returns "-" and not 0

[#4]

You could try this again:

=sum(IF(Month_PurNum<=NUM(month(today())),(JanValue_Pur),

IF(Month_PurNum>NUM(month(today())),(Jan_P))))

This is begining to be to hard without being able to look at the chart.

You could also try selecting Suppress When Value is Null for the Month_PurNum dimension. That would only work if it isa null value and not a blank value

[#5]

Do you have a personal email?