topic Re: Pass negative value if status is -1 when loading in App Development

Pass negative value if status is -1 when loading

Paula1 — Tue, 09 May 2023 17:38:52 GMT

As I do when loading, it passes the value with Status equal to -1, for a negative amount, like the example below.

Solution

Chanty4u — Tue, 09 May 2023 18:07:28 GMT

May be this

YourTable_Transformed:

LOAD

cod,

id,

Status,

If(Status = -1, -Qtde, Qtde) AS Qtde

RESIDENT Your

Table;

Or you can create a calculated dimension

=if(Status = -1, '(-)' & Dimension, Dimension)

Paula1 — Tue, 09 May 2023 18:29:00 GMT

🤗

Thank you so much, it was perfect