Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have been using the fx feature of adding a measure to a text box which is great, but I also want to color code these outputs for red as negative, green as positive numbers. Is this poss to control with the code?
An example of one of my measures is below:
(sum({<BudVsAct={"Budget"} ,ExpVsRev={"Expense"}, [Cost Centre]={23} >}[Period Balance])
-sum({<BudVsAct={"Actual"} ,ExpVsRev={"Expense"}, [Cost Centre]={23} >}[Period Balance]))/1000
And a get a text box with a combination of text and functions as per attached file, but I don't want to have to manually change the color to either red or green each month?
Thanks
Gus
Hi Gus,
Consider this as an example for properties panel,
definition: {
type: "items",
component: "accordion",
items: {
dimensions: {
uses: "dimensions",
min: 1,
max: 1
},
measures: {
uses: "measures",
min: 1,
max: 1,
items : {
xrefValue : {
type : "string",
label : "Colour Expression",
ref : "qAttributeExpressions.0.qExpression",
expression: "always"
}
}
},
sorting: {
uses: "sorting"
},
settings: {
uses: "settings"
}
}
},
snapshot: {
canTakeSnapshot: true
}
Thanks,
Sangram
Hi Reddys,
How should I write the code in paint:function after I done showing the expression input box in properties panel?
Thanks in advance!