Since i'm trying to find out the budget vs. actual I have the below code:
=sum({<[Application Status group before cancel (Application)]={'Approved'},[Disbursement Flag]={1}>}[Financed Amount (Application)])/Sum(Volumen) and then it's done in percentage.
So i've put the above code to segment 3 and colored it grey, while segment 1 is green.
I need it to show me red if below 0.80
Yellow from 0.80 to 0.90
and green from 0.90 to 1.00.
Anyone that could help me find out how I can do that?
Anis, what would be most helpful is if you can attach a QVW with the issue, that way folks can look at everything to try to sort out where the issue is occurring. It is quite difficult to try to help sometimes with just descriptions, the apps make it much more efficient to try to track things down. You do not have to attach the actual app, if you can create an example app with the issue, that will work just fine. If you are concerned about any confidential field contents, you can use the Settings\Document Properties\Scrambling tab to scramble those just in case that is the reason you are hesitant to post the app. This should help you get someone to provide some suggestions or figure out what is wrong.
Regards, Brett
To help users find verified answers, please do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question. I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.
Hi Anil, that link only uses two segments, the second segment is always grey, and first segment it's not a fixed green, it uses a calculated color based on percentaje of your expression:
If(sum({<[Application Status group before cancel (Application)]={'Approved'},[Disbursement Flag]={1}>}[Financed Amount (Application)])/Sum(Volumen)<0.8, RGB(255,0,0) //red
,If(sum({<[Application Status group before cancel (Application)]={'Approved'},[Disbursement Flag]={1}>}[Financed Amount (Application)])/Sum(Volumen)<0.9, RGB(255,255,0) //yellow
, RGB(0,255,0))) // green
As Brett says, if you upload a sample we can return it fixed.
.png "Former Employee"){kind=icon}
