Help with adding division "/" to a formula?

(0) Share

Report

Posted on by Usernametwice

503

Hi all

In this formula I am filtering a table in CDS based on a gallery selection and sorting it by some day numbers. This is shown in a graph. Now I need to divide a specific field of data by 1000 so that it can be displayed on a max y axis 100 line chart. So if the user enters 30,000 in the field, the graph would display 30 for example because it's being divided by 1000. So basically I need to add this to my formula and unsure how to do so.

Here is the formula with the division added on the end (which does not work yet) -

SortByColumns(Filter('Daily Measurement','day'.'day'=Gallery.Selected.'day'.'day'), "number",Ascending), "actual", ThisRecord.'Actual'/1000)

Any idea on how to do this?

Thanks for any help.

Kind regards.

Categories:

Building Power Apps

I have the same question (0)

All responses (1)

Answers (0)

JR-BejeweledOne 5,836 Moderator on at

Like (0)

Report
Copy link

Link copied!
Have you tried wrapping ThisRecord.'Actual/1000 in parens?

SortByColumns(Filter('Daily Measurement','day'.'day'=Gallery.Selected.'day'.'day'), "number",Ascending), "actual", (ThisRecord.'Actual'/1000))

Was this reply helpful? Yes No