Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
In one of my pivot table I have a group called as Time. Which contains fields such as =Week(date),=Year(date),=WeekName(date) and =MonthName(date). With that I want to one more fields which calculates only 2 weeks of data. It should show latest 2 weeks date only.
I tried something like =Date(Max(date)-14) but it didn't work.
Can some one help me out on this please.
Thanks
Rikeb
Deepak Kurup wrote:
For Light gray rgb(166,167,170) . see the attachment, you will come to know how i got the color<div></div>
I didn't asked anywhere for the color. It seems I confused you becuase of lots of post here.
What I might have asked is...
This is what I am using in the Properties --> Expressions --> Date(Field) --> Background Color --> Below code:
With that as you said I need to add this. I tried that in different way as show in my above post but it is not working as expected.
=if(weekday(date) ='Sat'or weekday(date) ='Sun',Rgb(255,0,0))
IF(A1='Change1' ,lightgray(),
IF(A1='Change2',lightred(),
IF(A1='Change3',yellow(),
IF(A1='Change4',lightmagenta(),
IF(A1='Change5',lightcyan(),
IF(A1='Change6',lightblue(),
green()))))))
If anything is not understandable please do let me know
Hi Deepak
To tell you in short in the attached application I want to add below code which you had given to the 'color' variable. Color variable is used in Properties --> Date --> Background Color. Can you please add your code to the color variable so that background color of weekends are in red along with the other condition.
=if(weekday(date) ='Sat'or weekday(date) ='Sun',Rgb(255,0,0))
color(Variable):
IF(A3='Approved' ,lightmagenta(),
IF(A3='Completed',Yellow(),
IF(A3='Implemented',cyan(),
IF(A3='In Progress',Green(),
IF(A3='Pending Approval',lightblue(),
IF(A3='Registered',Blue(),
IF(A3='Risk and Impact',darkgray(),
IF(A3='To Be Approved',lightgreen(),
lightmagenta()))))))))
hi,
sorry i didnt get it..
In the attached application
Goto: Settings --> Variable Overview --> Color
I using this variable(color) in the (Goto: Properties --> Expression --> Date --> Background color). This variable displays the background color according to the A3(Status). Along with this condition I want to display background color as red for weekends.
Hope it is understandable now! If not please do let me know. I will put it in someother way...
hi,
Check out the attachment. Is this what you are looking for.
Sorry this is not the one I asked for. What you did is you have removed $(color) from the background. What I need is background color should be displayed based on the condition in the variable along with below condtion.
=if(weekday(date) ='Sun'or weekday(date) ='Sun',Rgb(255,0,0))
I tried something like below but it didn't work:
IF(A3='Approved' ,lightmagenta(),
IF(A3='Completed',Yellow(),
IF(A3='Implemented',cyan(),
IF(A3='In Progress',Green(),
IF(A3='Pending Approval',lightblue(),
IF(A3='Registered',Blue(),
IF(A3='Risk and Impact',darkgray(),
IF(A3='To Be Approved',lightgreen(),
if(weekday(date) ='Sun'or weekday(date) ='Sun',Rgb(255,0,0),
lightmagenta())))))))))
Hope it is understandable now [:'(]
hi Attitude,
See my attachment above . I have use only keyword and its working fine
if(only(weekday(date))= 'Sun',rgb(255,0,0))
Deepak Kurup wrote:
See my attachment above . I have use only keyword and its working fine
if(only(weekday(date))= 'Sun',rgb(255,0,0))<div></div>
But in the above attachment you have removed the variable(color) from the value(expression tab) background and you are using only the above code. But where what I need is I want to use variable 'color' along with the above code. I think you didn't see the variable yet that's why the confusion is.
Please look into it and help me out. It is little urgent!
Try this application
Hi Deepak
The application which you have attached is not working. Below code has done the trick!
if(only(weekday(date))='Sat' or only(weekday(date))='Sun',rgb(255,0,0),
IF(A3='Approved' ,lightmagenta(),
IF(A3='Completed',Yellow(),
IF(A3='Implemented',cyan(),
IF(A3='In Progress',Green(),
IF(A3='Pending Approval',lightblue(),
IF(A3='Registered',Blue(),
IF(A3='Risk and Impact',darkgray(),
IF(A3='To Be Approved',lightgreen(),
lightmagenta()))))))))