Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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))
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)))
It returns "-" and not 0
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
Do you have a personal email?