Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
LhZagora
Contributor
Contributor

If function

Hello Experts

 

I have data with colunms as below :

LhZagora_0-1588262510787.png

 

and i have variable to get the closest number ,

LhZagora_1-1588262560590.png

 

and i a have new created measure that equal to (below)

LhZagora_2-1588262784853.png

 the problem that i get always Ps new vs equal to 0, even that my Closest number variable its a value that get from Vs. !!!

 

Can someone help please why the condition is not satisfied !!!!

2 Replies
Wlad_Masi
Employee
Employee

Hi @LhZagora,

 

Please create one text pane with your variable =$(variable) and a text pane or a table with your if statement.
Does it displays the result you are looking for?
Please use filter panes to select data and check results.
Please let me know if it helps to figure things out.

To help users find verified answers, please don't forget to mark a correct resolution or answer to your problem or question as correct.
Wlad_Masi
Employee
Employee

Hi @LhZagora ,

Did my previous comment helped you?
If not please let me know what was the result.

To help users find verified answers, please don't forget to mark a correct resolution or answer to your problem or question as correct.