Announcements
cancel
Showing results for
Did you mean:
MVP

## Sum With Condition

Hi All,

I want  exclude only actual value for max quarter

in the attached app i have mentioned the requirment and result too,

1 Solution

Accepted Solutions
Master II

Try like this.

=max({<Quarter={\$(=concat(chr(39) & Quarter & chr(39),',') )}>}Actuals)+max({<Quarter={\$(=concat(chr(39) & Quarter & chr(39),',') )}>}Forecast)

9 Replies

Sum({<Quarter={"\$(=MaxString(Quarter))"}>} Forecast)

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
MVP
Author

No anil.  its showing only for max sum forecast i need  both selected means

max quarter forecast and other selected actual

Master II

Try like this.

=max({<Quarter={\$(=concat(chr(39) & Quarter & chr(39),',') )}>}Actuals)+max({<Quarter={\$(=concat(chr(39) & Quarter & chr(39),',') )}>}Forecast)

MVP

This?

RangeSum(Sum({<Quarter={'\$(=maxstring(Quarter))'}>}Forecast),Sum({<Quarter-={'\$(=maxstring(Quarter))'}>}Actuals))

MVP
Author

thanks Tresesco B

this is my original expression  how can i incorporate in this?

if(Quarter=vMaxQtr  and  otherQtr Selection ,\$(vFc)+\$(vAc))

MVP

You might have to create two new variables for this, because you need to include set analysis in it.

Partner - Creator

MVP
Author

this is my original expression  how can i incorporate in this?

here how can i use and condition in if  ?

=IF(Quarter = vNewMaxQtr,((\$(vFCYOYServ)-\$(vACTYOYServ)) / \$(vACTYOYServ))

,

if(Quarter =\$(vQtr) and Quarter=vNewMaxQtr, (\$(vFCAMultiple)- \$(vACTYOYServ))/\$(vACTYOYServ),((\$(vCurACTYOYServ)-\$(vACTYOYServ)) / \$(vACTYOYServ))) )

second if i not working

vQtr = Quarter field  only

vNewMaxQutr = 2018Q3

Contributor III

Hi ,

can you share excel sheet of data.

Community Browser