Hi all
I have been posting but it remain unsolved (SO I am re editing message & title)
In a page I am struggling with creating a contextualization in the formulas of the entire page
My overall attempt : contextualize depending on the business name that appear on an item somewhere in the page
Seems simple ? yes but so far I never found the right approach
The initial formula (that is working well
)
Text(
Sum(
Filter(
'PROJECTDB';
BUSINESS1>= 1);
(BHWQ1+BSWQ1+BINQ1+BEXQ1+BHWQ2+BSWQ2+BINQ2+BEXQ2+BHWQ3+BSWQ3+BINQ3+BEXQ3+BHWQ4+BSWQ4+BINQ4+BEXQ4)*BUSINESS1/100)
/1000;"[$-en-us]#,##")
So: I am creating an Item called BUSINESSNAME and for this page the value is BUSINESS1 and I am trying this formula
Text(
Sum(
Filter(
'PROJECTDB';
Value(BUSINESSNAME.Text) >= 1);
(BHWQ1+BSWQ1+BINQ1+BEXQ1+BHWQ2+BSWQ2+BINQ2+BEXQ2+BHWQ3+BSWQ3+BINQ3+BEXQ3+BHWQ4+BSWQ4+BINQ4+BEXQ4)*Value(BUSINESSNAME.Text)/100)
/1000;"[$-en-us]#,##")
or this formula :
Text(
Sum(
Filter(
'PROJECTDB';
BUSINESSNAME.Text >= 1);
(BHWQ1+BSWQ1+BINQ1+BEXQ1+BHWQ2+BSWQ2+BINQ2+BEXQ2+BHWQ3+BSWQ3+BINQ3+BEXQ3+BHWQ4+BSWQ4+BINQ4+BEXQ4)*ValueBUSINESSNAME.Text/100)
/1000;"[$-en-us]#,##")
always the same results : no results (empty Item) Instead of properly proceeding the calculation - I know that the 1st way to proceed should work ! but it does not work (probably due to the other elements of the formula)
Any Idea? I am REALLY Struggling with it !
Many thanks
BR
Jean fred
Label1 is the entire object. If you want to read the text property of the label, you have to use Label1.Text
Text(
Sum(
Filter(
'DBNAME';
Value(Label1.Text)>=0);(BHWQ1+BSWQ1+BINQ1+BEXQ1+BHWQ2+BSWQ2+BINQ2+BEXQ2+BHWQ3+BSWQ3+BINQ3+BEXQ3+BHWQ4+BSWQ4+BINQ4+BEXQ4)*BUSINESSNAME/100)
/1000;"[$-en-us]#,##")
Thank yu for the kind support
unfortunatelly when applying it it does not work (both solution show an empty item instead of the expected result 😞
The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.
This training provides practical hands-on experience in creating Power Apps solutions in a full-day of instructor-led App creation workshop.
User | Count |
---|---|
183 | |
46 | |
46 | |
34 | |
33 |
User | Count |
---|---|
260 | |
87 | |
79 | |
68 | |
67 |