Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi there,
Im my model I would like to have a fix filter on one sheet , regardless of what the user is choosing, The only field that change will be the date field.
example ...
I want to do the sum always when Cores is <=4 but when Status is base then sum Processor *.20 and when Status is New then just sum processor. But I want the values to change based on the date the user selected
sum(if(cores <=4, processor * if(Status='Base',0.20,if(Status='New',1,1))))
Try something like: sum({1<Date=p(Date)>}if(cores <=4, processor * if(Status='Base',0.20,if(Status='New',1,1))))