cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Route217
Responsive Resident
Responsive Resident

Show Percentage as Number as Opposed to text

Hi Experts

 

How could i amend the following as number so the if conidition is met and i can apply my CF Rule

 

VAR _DutyPercentage =
IF(FORMAT(DIVIDE(_duty,_external,0),"0.0%;(0.0%)")<0,1,0)
 
The above is still as a text value
1 ACCEPTED SOLUTION

@Route217 

 

Ok, try:

IF(DIVIDE(_duty,_external,0) <0,1 , 0)




Did I answer your question? Mark my post as a solution!
In doing so, you are also helping me. Thank you!

Proud to be a Super User!
Paul on Linkedin.






View solution in original post

3 REPLIES 3
PaulDBrown
Super User II
Super User II

@Route217 

Where does this expression come from _duty,_external,0





Did I answer your question? Mark my post as a solution!
In doing so, you are also helping me. Thank you!

Proud to be a Super User!
Paul on Linkedin.






Route217
Responsive Resident
Responsive Resident

_Duyt and _External are other VAR in my formula..

VAR _external =
SUMX (
FILTER (
ALL ( Logistics_ ),
Logistics_[New_Reporting_Headers]="External Sales"
),
[__v_Act2020]
)
VAR _Duty =
SUMX (
FILTER (
ALL ( Logistics_ ),
Logistics_[New_Reporting_Headers]="Duty"
),
[__v_Act2020]
)

 

@Route217 

 

Ok, try:

IF(DIVIDE(_duty,_external,0) <0,1 , 0)




Did I answer your question? Mark my post as a solution!
In doing so, you are also helping me. Thank you!

Proud to be a Super User!
Paul on Linkedin.






View solution in original post

Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

March Update

Check it Out!

Click here to read more about the March 2021 Updates!

secondImage

The largest Power BI virtual conference

100+ sessions, 100+ speakers, Product managers, MVPs, and experts. All about Power BI. Attend online or watch the recordings.

secondImage

Experience what’s next for Power BI

See the latest Power BI innovations, updates, and demos from the Microsoft Business Applications Launch Event.